Excel Forum
Similar Content
Return the Min or Max Value Using a Lookup in Excel - INDEX MATCH
Tutorial: Find the Min or Max value in a range and, based on that, return a value from another rang...
SUMIF - Sum Values Based on Criteria in Excel
Tutorial: The SUMIF function allows you to sum values based on a single criteria. This function wor...
MODE() - Find Most Repeated Value in a List in Excel
Tutorial: The MODE() function in Excel allows you to quickly find the most repeated or frequently oc...
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




Excel Magic Trick 409: VLOOKUP MAX Value, Return More Than 1 Record


See how to find the Max statistics in each category and return the names associated with those stats, even when there are duplicates. See the COUNTIF, MAX, IF, ROWS, INDEX, SMALL and ROW functions in an array formula. Lookup one value and return duplicates.





Got a Question? Ask it Here in the Forum.