Dueling Excel 54

Approximate Lookup To Return Multiple Items


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.


Be the first to comment

Leave a Reply