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,