Compare and move data

I have an 2 csv files, one has multiple lines of the sames part number. And the other just one line of the part number with the cost associated with it. I am looking to compare the two, and move the cost column over to the one with multiple lines, but i want to automate the multiple lines with the cost from the other file. Basically compare sheet one to sheet 2 and move the associated cost file to the sheet 2, and automate it for the multiple lines.

(e.g.)
Sheet 1

Columun 1 Column2
13066 13.50

Sheet2

Column1 Column2
13066
13066
13066

Hi Frankkerby,

Use the below formula in the Sheet2 Column 2.

= vlookup(Column2Row2,Sheet1Column1:Column2,2,0)

Hope this helps. If not, try attaching the file ans we can look into it.

Best Regards,
Tarun Juneja
Excel-o-ratoR

I have tried your code, but i cannot get it to work. I have started a new post with the files atttached; http://www.excelforum.com/excel-prog...ata-files.html