If I had a nickel for every time I used a VLOOKUP with True/Approximate match, I’d be a very poor man. But while it might be less common than its False/Exact match counterpart, approximiate (aka “fuzzy“) match serves a very specific — and important — purpose.

In this tip, we’ll use fuzzy match lookups to assign specific discount rates based on sales quantity.

COMMON USE CASES:

• Defining variable commission rates based on agent sales volume
• Calculating tiered discounts based on purchase quantity