excel partial match in any of the lookup data

[chaitanya1124]

I have data in column A and B have lookup data. If the any of the lookup data is partially matching in the result column need to put lookup data.


I tried with VLOOKUP but no luck. Please help me.


Columns:

  A                                                    B(Lookup)            C(Result)
    FY|F|V|D|Safety|3M                         Toro                     3M
    FY|F|V|D|POP|ToroDays                    3M                      Toro
    FY|F|V|D|Lumber|GroundContact      honeywell            NA(Not available)
    FY|F|V|D|airfilters|honeywell            samsung              honeywell

 

[FDibbins]

Your sample and expected results are hard to read, can you try again, and explain what you have and what you want?

 

[ketxu]

You can use Vlookup with wildcard, , just add "*" & Whatofind & "*" at lookup value for finding partial match string
P/s : could you post your file ?

 

[Marcelo Branco]

Maybe...

	A​	B​	C​
1​	Data​	Keywords​	Result​
2​	FY|F|V|D|Safety|3M​	Toro​	3M​
3​	FY|F|V|D|POP|ToroDays​	3M​	Toro​
4​	FY|F|V|D|Lumber|GroundContact​	honeywell​	NA​
5​	FY|F|V|D|airfilters|honeywell​	samsung​	honeywell​

Formula in C2 copied down
=LOOKUP(2,1/ISNUMBER(SEARCH(B$2:B$5,A2)),B$2:B$5)

M.