Merging two files

I need help with merging two Excel files. Test 1 file has two colums Part number and Description. Test 2 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. The list of products is thousands and thousands, they are not in the same order in these two files, so I need them matched based on the part number. Please help.

Hi oceanmd,
You can use a vlookup formula to look up the part number and bring in the price. In your example, enter the following formula into cell C2 in Test1.xls: =VLOOKUP(A2,[Test2.xls]Sheet1!$A$1:$B$4,2,FALSE)

This looks up the value in A2, looks at the table A1:B4 in the Test2 file, and brings back the second column (the price).

Hope this helps,
Adam

Thank you, it worked perfectly.