compare values in 2 columns if match found return 3rd column else return blank

[mdavid]

Hi Col A has multiple repeating item numbers, col B has list of unique item numbers. If item number appears in A and B then return value in col C of row that item number appears in col A. If no match return blank
Attached example with expected results in col D.
Any help much appreciated.
Thanks

 

[Monty]

Hello

This should work

=IF(ISNUMBER(MATCH(A2,B:B,0)),VLOOKUP(A2,A:C,3,FALSE),"")

 

[mdavid]

Thanks very much Monty, worked perfectly.

 

[GraH - Guido]

If you have a modern excel version, it might be very simple. Just one formula that spills the result.
=XLOOKUP(A2:A24,B2:B24,C2:C24,"")

Or using some legacy function, no need to have a double lookup like presented in #2.