Append column to list based on match

[dougw03]

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.