Try

In sheet A put this formula in B2 =VLOOKUP(A2,Sheet2!$A$1:$B$20,2,0)
and drag it.




On Sep 15, 10:34*am, Andri wrote:
Dear All,

Please help to solve it by FORMULA.

I have a database e.g 20 Rows, the fields Product Name, SN, etc (Sheet A)

I would like to concatenate the SN, if match with the product Name (Sheet B).
For Example : if Col A, Product Name = Computer, Col B, i want to be text
the SN like this (A1234, B1234, C1234) from the database in Sheet A.

thank you for your kind attention and help.

TIA and respectfully,
andri