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])
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.
I tried that but return result show 0
otherwise if i have 2 criteria as first look supplier and another look keyword then lookup and return Flag
so please advise.
Supplier keyword Flag ABC Clipboard Y ABC Tape N TEETH Tooling Y Supplier description Flag ABC Elephant plastic tape 3 rolls TEETH Clinical toolings for dentist Nice try!! https://www.godrejsplendour.org.in
- That is because you have blank rows in the left table. Blank rows/columns in a table is a NoNo.
For your second question:
=LOOKUP(9^9,SEARCH(Tabelle2[keyword],F2)/(Tabelle2[Supplier]=E2),Tabelle2[Flag])
