You can use VLOOKUP for this, or an INDEX/MATCH combination. Give us
some idea of which columns you are using on the sheets if you want a
specific formula to do it.

Pete

On Nov 12, 5:26*pm, Pendal wrote:
I have a worksheet that has two sheets to it

on sheet A i have a list of product codes and the name of an image that goes
with them

on sheet B i have a list of products codes and the productID number from my
database.

what i need to do is search sheet B for the product code that matches sheet
A and then insert the productID onto sheet A

is there an easy way to do this?

Thanks,