Loading…
Loading…
With TRUE (or no 4th argument) VLOOKUP does an approximate match: it finds the largest value that is less than or equal to yours. The first column must be sorted ascending. This is perfect for grade bands, tax brackets and commission tiers.
Syntax
VLOOKUP(value, table, col, TRUE)
Example: With thresholds 0, 50, 60, 70, 80 a score of 72 lands on the 70 row.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.