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