Forum Discussion
Solved
Reverse Partial Match
I have item description and need to find supplier name with partially keyword as below exam (lookup value is column4 and lookup array is column2 , return result is column1 place on latest column) ...
=LOOKUP(9^9,SEARCH(Tabelle2[keyword],D2),Tabelle2[Supplier])
=LOOKUP(9^9,SEARCH(Tabelle2[keyword],D2),Tabelle2[Supplier])
Detlef_Lewin Thank yo so much. In additional, Can we adapt or apply this like Vlookup as find in multiple rows ?
example
| Supplier | Keyword |
| ABC | Clipboard |
| HAMTON | Tape |
| LAKE | Box |
| BESTZ | Tooling |
| Description | Supplier |
| Blue thick box with full load | |
| Strong elephant clipboard Size L |