Hi,
I’m trying to compare two sheets. On both sheets are product codes (both in column A) of which some are matching. When a product code matches I want the adjacent cell on sheet 2 (column B, price) to be copied to the column C on sheet 1 (in the same row as the matched name).

I have searched quite a lot to find a (suitable) solution but I have failed so far.

Thanks in advance.

Best regards

Maarten