Excel Forum



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





Got a Question? Ask it Here in the Forum.