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