Dueling Excel 54


Approximate Lookup To Return Multiple Items

DESCRIPTION

See Mr Excel and excelisfun create solution to do an approximate lookup to return multiple items. See VBA solution and array formula solution. Also see Excel 2010 AGGREGATE function that can handle arrays and does not require Ctrl + Shift + Enter.

WORKBOOKS