VLOOKUP w Approximate Match & Unsorted Table
See Mr Excel and excelisfun do a VLOOKUP for an approximate match when the table is not sorted. See Mr Excel create the exact match for his lookup with the MIN, IF, MATCH and INDEX functions. See excelisfun use the SMALL, ROWS and LOOKUP functions to sort the table inside the formula and to an approximate match.
PodCast 1144 Learn Mr Excel
Amazing Excel Trick.