Dueling Excel 036


VLOOKUP w Approximate Match & Unsorted Table

DESCRIPTION

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.

WORKBOOKS




Be the first to comment

Leave a Reply