Forum Discussion

DaanvdM's avatar
DaanvdM
Copper Contributor
Aug 25, 2022

Extracting Exact word match with a pre-defined list into an new corresponding column

Good day,   I have spend probably too long trying to figure out this problem. In Sheet 1 there is a list of Brands: BRAND RUWAG ZEBRA EASIGAS AFROX LIBERTY MTS In Sheet tw...
excel
office 365
Harun24HR's avatar
Harun24HR
Bronze Contributor
Aug 25, 2022

DaanvdM If you are on Microsoft-365 then can try below formula.

=FILTER($A$2:$A$7,ISNUMBER(SEARCH($A$2:$A$7,D2)),"No Match")

For array approach can try BYROW() lambda function.

=BYROW(D2:D8,LAMBDA(x,FILTER($A$2:$A$7,ISNUMBER(SEARCH($A$2:$A$7,x)),"No Match")))

 

 

Resources