Excel Forum



Mr Excel & excelisfun Trick 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.





Got a Question? Ask it Here in the Forum.