Excel Magic Trick 323: Partial Text VLOOKUP (Fuzzy Match)

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