Concanating text using vlookup forumula

gannesh0604 Posts 25 Registration date Thursday July 20, 2023 Status Member Last seen June 1, 2024 - Jun 1, 2024 at 06:06 AM


Anybody help me to suggest a formula .

 Attached Sample file link Below:

I am looking for formula at B11 .. it gives the below suggested text. red colored text will come from Main database sheet. Make sure the formula checks that Pin end finish & Box finish cell values based on I1 cell. the formula left the empty reference values and give text reference cells header name followed by text cell names ..

Sample result:

M002/24-5(I1) : Surface treatment as per Spec 1 ( Box end finish - Mn Phosphate)

M002/24-6 (I1): Surface treatment as per Spec 1 ( Pin end finish - Zn Phosphate)