Combining 2 lists w/many duplicates but adding an additional column

[jenel25]

Full disclosure - my Excel skills are pretty limited. Here's my challenge:

I have an older list of about 8,700 license holders with just two columns, Name and Email Address.

My second, new list of about 8,200 license holders consists mostly of the same names (exact match), but with many new licensees added/deleted. This list has multiple columns, but does not include an email address column.

My ultimate goal is to combine the two spreadsheets and assign email addresses to matching contacts on the newer list. I naively thought this would be pretty straightforward, but I've quickly learned otherwise. Any help would be greatly appreciated!

[Sam Capricci]

have a look at vlookup, something like =VLOOKUP(A2,OldList!A:B,2,FALSE)
So that is A2 would be the cell with the person's name or identifying characteristic that matches between both tabs from the new list tab.
OldList!A:B assumes that in column A is the person's identifying characteristic (maybe name) that matches the new list, and column B is where the information is you want returned. The 2 means you go over 2 columns (from column A to column B and return what is in col B when it finds a match in A). False means find an exact match.
change as your data requires.
hope that helps.

[José Augusto]

Hi

I suppose you can use the VLOOKUP function to do that

If list one are in a sheet 'List One'!A2:B_n and and the other list are in sheet 'List Two'!A2:A_n
use the following formula in 'List Two'!B2 and drag down

Please Login or Register  to view this content.

See the file

[jenel25]

Thank you! Success!