Excel Forum
Similar Content
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...
Vlookup Macro to Return All Matching Results from a Sheet in Excel
Macro: This Excel Macro works like a better Vlookup function because it returns ALL of the matchi...
Remove Spaces Between Text in Excel
Tutorial: How to remove spaces from the middle of text in Excel.  This includes removing all spaces ...

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.