Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge rows from 2 XLS files using a common key field.
I have 2 Excel files with customer records. Each file has a common customer
number and the other fields are different. I would like to combine the data into one file by using the common customer number to link the related records from the 2 spreadsheets. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge rows from 2 XLS files using a common key field.
Hi,
If there is a unique identifier you might consider using =VLOOKUP(Key,Table,Col,Type) Where you place the formula in one file and the Key is the common identifier, Table is the data in the other file (the Key must be found in the leftmost column of the Table range), Col is the column of the Table you want to return, counted from left to right in the table range, Type indicates whether you want an approximate or an exact match, in your case exact, so you should use False (or 0). Cheers, Shane Devenshire Microsoft Excel MVP "Gene" wrote: I have 2 Excel files with customer records. Each file has a common customer number and the other fields are different. I would like to combine the data into one file by using the common customer number to link the related records from the 2 spreadsheets. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add data based on a common field | Excel Worksheet Functions | |||
merge worksheets which share a common column? | Excel Worksheet Functions | |||
How do I merge or combine 2 excel worksheets by a common collumn? | Excel Worksheet Functions | |||
How do I merge 2 excel spreadsheets containing some common info? | Excel Worksheet Functions | |||
Excel: how to merge data from 2 workbooks with 1 col. in common? | Excel Discussion (Misc queries) |