I have two spreadsheets that I am trying to verify and link some information.
First, there is a master spreadsheet with about 40,000 First and last names, email addresses and mailing addresses (call this spreadsheet Master). The second spreadsheet is shorter with only about 200 of the same information (Spreadsheet 2). What I would like to do is for excel to take the information in spreadsheet Master, to see if it can find the matching name in spreadsheet two and to fill in the email address for that person from spreadsheet Master into the second spreadsheet.
The two spreadsheets aren't formatted the same. The Master has the emails in Column A, First and Last name in Column B. Sheet two has the emails in Column P, Last name in Column L, and the First name in Column M.
Is this possible? If so, how would I do it so that I don't have to manually go through the Master to see if there are any of the 200 names from the second? I have Excel 2007.
I've tried watching tutorials, but all of the Excel language and formulas are overwhelming when none of the ones I've seen have an example of exactly what I need. Any help would be much appreciated.
Jennifer
First, there is a master spreadsheet with about 40,000 First and last names, email addresses and mailing addresses (call this spreadsheet Master). The second spreadsheet is shorter with only about 200 of the same information (Spreadsheet 2). What I would like to do is for excel to take the information in spreadsheet Master, to see if it can find the matching name in spreadsheet two and to fill in the email address for that person from spreadsheet Master into the second spreadsheet.
The two spreadsheets aren't formatted the same. The Master has the emails in Column A, First and Last name in Column B. Sheet two has the emails in Column P, Last name in Column L, and the First name in Column M.
Is this possible? If so, how would I do it so that I don't have to manually go through the Master to see if there are any of the 200 names from the second? I have Excel 2007.
I've tried watching tutorials, but all of the Excel language and formulas are overwhelming when none of the ones I've seen have an example of exactly what I need. Any help would be much appreciated.
Jennifer
Last edited:
