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)
i known on partial match but in this case just reverse direction and i don’t have any idea.
How to do this one ?
| Supplier | keyword | Description | Supplier | |
| ABC | Clipboard | The BBL black Clipboard size L |
=LOOKUP(9^9,SEARCH(Tabelle2[keyword],D2),Tabelle2[Supplier])
10 Replies
Working thanks https://www.godrej-ananda.net.in
=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 - The formula already does that.
