Merge 2 excel files, or move data from xls 1 to xls 2 to the right rows?

**scalare** · 04-10-2013, 02:13 AM

Hi.
We have 2 excel files every month with many colums. On column is on both xls files, social security number.

I would love if there is a function in excel or maybe you could script this. Is to search and match rows pedning on social security number and add the missing data to one of the xls docs.

So like this
XLS1
* Social security number column
* Data 1 column

XLS2
* Social security number column
* Data 2 column

XLS3 or merged fixed xls
* Social security number column
* Data 1 column
* Data 2 column

Hopefully you understand my request! Thanks.

**arlu1201** · 04-10-2013, 02:26 AM

Do you have samples that you can upload of books 1 and 2? If we use dummy files that we create for you, you may not be able to replicate the same in your files, so its better you attach a sample of your files.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**wenqq3** · 04-10-2013, 02:37 AM

XLS1
* Social security number column (column A)
* Data 1 column (column B)
vlookup at column C
=VLOOKUP( value, table_array, index_number, false)
eg: VLOOKUP( value at xls1 "A2", table_array at xls2 "A:A", index_number "2", FALSE )

hope this help