![]() |
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