ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Merge two files based on one column (https://www.excelbanter.com/excel-discussion-misc-queries/252261-merge-two-files-based-one-column.html)

Marc

Merge two files based on one column
 
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.


All times are GMT +1. The time now is 04:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com