Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge two excel files like in word mail merge | Excel Discussion (Misc queries) | |||
Merge 2 Files | Excel Discussion (Misc queries) | |||
how do I merge two files? | Excel Discussion (Misc queries) | |||
merge csv files into spreadsheet | Excel Discussion (Misc queries) | |||
MERGE 2 FILES | Excel Discussion (Misc queries) |