excel Using VLOOKUP with approximate matching.


When the range_lookup parameter is either omitted, TRUE, or 1, VLOOKUP will find an approximate match. By "approximate", we mean that VLOOKUP will match on the smallest value that's larger than your lookup_value. Note that your table_array must be sorted in ascending order by lookup values. Results will be unpredictable if your values are not sorted.

enter image description here