Previous Topic Next Topic

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

Hi,

Anybody help me to suggest a formula .

 Attached Sample file link Below:

https://we.tl/t-gQD0tFH6Rh

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)

Regards,

Ganesh

Similar discussions

Match partial text string in one sheet to another text string in another sheet
Santos -
Santos -

2 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Conditional Formatting in a vlookup
attycuz -
TrowaD -

1 response
Find missing data in 2 columns (Excel)
dalami81 -
dalami81 -

2 responses
Using Vlookup to return insted of 00/01/1900
Tom9o -
tom9o -

2 responses