Append column to list based on match

Hello,

This is my first post, so let me know if I'm not clear. Lets say I have a list of 10,000 rows with columns for
SSN/DOB/ETHNICITY
eg 123456789/feb-2-1950/White

Assume all SSN are unique. lets say I also have a seperate list of 8000 rows with unique SSN

SSN/HAIR COLOR

I want to append HAIR COLOR column to my original spreadsheet. However, not all entries will have HAIR COLOR. I cannot just sort both lists by SSN then copy the HAIR COLOR COLUMN to the end of the other list after ETHNICITY. Is there an easy way to do this so that HAIR COLOR will have blank rows where necessary and matched by SSN on the appropriate other rows.

try:

=IF(ISNUMBER(MATCH(A2,SHEET2!A:A,0)),VLOOKUP(A2,SHEET2!A:B,2,FALSE),"")

where A2 is the first SSN on your active sheet, and Sheet2, columns A:B contain the SSN/Hair colour data.

copied down.

Did not refresh - n beat me !! and with a more comprehensive answer!

please post your workbook and i'll show you how i have carried out this task in the past. its a ball ache if you dont want to use access..... but can be done