Excel Forum
Similar Content
FILTER() Function Excel - Power Lookup for the Future
Tutorial: The new FILTER() function for Excel 365 allows you to do amazing things with a single sim...
Vlookup to Return the Min, Max, or Average Value in Excel
Tutorial: Perform a Vlookup that returns the highest value, lowest value, or average value from a d...
Vlookup Macro to Return All Matching Results from a Sheet in Excel
Macro: This Excel Macro works like a better Vlookup function because it returns ALL of the matchi...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.