Merging two Excel files

**oceanmd** · 12-16-2008, 10:48 AM

I need help with merging two Excel files. 2009 Item List.xls file has two columns Part number and Description. Price.xls file has two colums: part number and price. I need to merge them into a file that whould have three colums: part number, description, price. There 6712 rows in 2009 Item List.xls and 4743 rows in Price.xls file. So I need them matched based on the part number, and have the cells blank for the part numbers for which the price was not assigned.
Please help.
Thank you

**EdMac** · 12-16-2008, 11:28 AM

In the first sheet ,use VLOOKUP to lookup the price values from the second

**oceanmd** · 12-16-2008, 11:42 AM

This is as much as I know. Will you please write the exact formula, so that I can copy it and paste in the file.

Thank you very much

**EdMac** · 12-16-2008, 11:49 AM

Try this in the first cell, (adjust the cell range Red for the second sheet) and then copy down

Please Login or Register  to view this content.

**oceanmd** · 12-16-2008, 12:01 PM

It's not working. I pasted it in C2 cell in the first file, and adjusted cell range to 25 for the second file. I am testing it on the very same files I have attached to his e-mail. If I can get it to work on the shortened version, I guess I would only have to adjust the B range for the real files.

Will you please try again.
Thank you

**EdMac** · 12-16-2008, 12:07 PM

It worked for me on your files - make sure both are open.

You say

It's not working

What do you get?

**oceanmd** · 12-16-2008, 12:16 PM

EdMac,

This is the formula that I entered
=IF(ISNA(VLOOKUP(A2,[Price.xls]Sheet1!$A$2:$B$25,2,FALSE)),"",VLOOKUP(A2,[Price.xls]Sheet1!$A$2:$B$25,2,FALSE))

and nothing happens, no error messages, C2 cell is blank, when you select it, the formula shows in the formula bar.

**EdMac** · 12-16-2008, 01:10 PM

It should work Ok unless the file you are using has the names or prices in different columns to those in the formula - try using the formula auditing tool to trace the progress of the calulation.