Problem matching data from two sheets

[execbp]

Ok, here is the situation...any help is sincerely appreciated. I tried to search on this problem, but I had no luck. Sorry if this is a bit long. I just want to be thorough.

I have a spreadsheet of my product catalog from my supplier. The spreadsheet will be used to import my catalog into my website. There are 5340 items. There is a column for a unique reference number, part number, my price, retail price, weight, etc. Everything but the column with the web image file name. Call this spreadsheet 1.

For some reason, probably the fact that each customer gets different pricing and does not have access to all the products, the web image file name is in a seperate spreadsheet, very similar to the first one, with the key exception that my price is not contained on it.

So, I need to insert the column with the web image file name into spreadsheet 1 based on matching the reference number between sheets 1 & 2. In other words, copy the cell containing the image file name from reference number 1001 on spreadsheet 2, and paste it into a blank cell next to reference number 1001 on spreadsheet 1, and so on...yet ignoring the non-matching reference numbers.

Here's where it gets interesting: spreadsheet 2 has 54 more items than spreadsheet 1, and not right in a row, they are completely jumbled throughout. There are numbers on 1 that are not on 2 and vice versa. I need image files for the 5340 items on sheet 1, I can discard the extra 54 items.

Please let me know if there is anything I can do to clarify this further.

Thanks
Greg

[execbp]

looks like a VLOOKUP took care of this.