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...


[Table="class: grid"][tr][td="bgcolor: #DCE6F1"][/td][td="bgcolor: #DCE6F1"]

A​

[/td][td="bgcolor: #DCE6F1"]

B​

[/td][td="bgcolor: #DCE6F1"]

C​

[/td][/tr]
[tr][td="bgcolor: #DCE6F1"]

1​

[/td][td]

Data​

[/td][td]

Keywords​

[/td][td]

Result​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

2​

[/td][td]

FY|F|V|D|Safety|3M​

[/td][td]

Toro​

[/td][td]

3M​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

3​

[/td][td]

FY|F|V|D|POP|ToroDays​

[/td][td]

3M​

[/td][td]

Toro​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

4​

[/td][td]

FY|F|V|D|Lumber|GroundContact​

[/td][td]

honeywell​

[/td][td]

NA​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

5​

[/td][td]

FY|F|V|D|airfilters|honeywell​

[/td][td]

samsung​

[/td][td]

honeywell​

[/td][/tr]
[/table]

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

M.