Download Excel Start File: [ Ссылка ]
Download Excel Finished File: [ Ссылка ]
Two formulas: VLOOKUP function with wild card criteria for the lookup_value and LOOKUP / SEARCH functions formula with 2^15 number. See what happens when there are duplicates: the two formulas behave differently (VLOOKUP returns first and LOOKUP SEARCH returns last).
From Mr Excel Message Board
Fuzzy Match
