Merge two files based on one column

M

Marc

Hi, I have the following two files

File 1:
Column1, Column2, Column3, Column4, Column5
SSN1, First1, Last1, Street1, Zip1
SSN2, First2, Last2, Street2, Zip2
SSN3, First3, Last3, Street3, Zip3

File 2:
Column1, Column2, Column3, Column4
SSN1, City1, State1, Country1
SSN2, City2, State2, Country2
SSN3, City3, State3, Country3

I need to merge the two files based on Column1. How do I do that? Vlookup
only lets me add one column in file1. I want to merge both files based on SSN.
 
Top