If match between two sheets, copy adjacent cell from sheet 2 to sheet 1?

[VBnoob]

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

[NBVC]

You can use VLOOKUP or SUMIF

e.g

=IFERROR(Vlookup(A2,'Sheet2'!A:B,2,FALSE),"")


or

=SUMIF('Sheet2'!A:A,A2,'Sheet'!B:B)

The Vlookup finds the first (and if unique, only) match. If not found it returns a blank.

The Sumif finds all matches (and if unique, only match). If not found it returns a 0.

[Richard Buttrey]

Hi,

You need to use VLOOKUP() in Sheet1 column C. e.g.

Please Login or Register  to view this content.

obviously change the B100 to cover your actual range in sheet2.

Regards

[VBnoob]

Thank you both, I had already tried vlookup but I made an error in the table array. Now it works!

Best regards

Maarten