INDEX + MATCH + MAX (find the top item) Function in Excel: Syntax, Examples and Free Practice
INDEX + MATCH + MAX (find the top item) is an Excel Lookup & Reference function. Finds the highest number in a range, then uses MATCH+INDEX to pull back the LABEL associated with it.
INDEX + MATCH + MAX (find the top item) syntax
Arguments
name_range: Range of labels/namesvalue_range: Range of numbers to find the max in
When to use INDEX + MATCH + MAX (find the top item)
Finding which salesperson had the highest sales, not just what the highest number was.
Practice INDEX + MATCH + MAX (find the top item) online, free
Open the live Excel-style spreadsheet and try INDEX + MATCH + MAX (find the top item) yourself. No Excel install or sign-up needed to start.
Practice INDEX + MATCH + MAX (find the top item) now →More Lookup & Reference functions
Frequently asked questions
What does the INDEX + MATCH + MAX (find the top item) function do in Excel?
Finds the highest number in a range, then uses MATCH+INDEX to pull back the LABEL associated with it.
What is the syntax of INDEX + MATCH + MAX (find the top item) in Excel?
The syntax is =INDEX(name_range, MATCH(MAX(value_range), value_range, 0)). name_range: Range of labels/names; value_range: Range of numbers to find the max in.
Where can I practice INDEX + MATCH + MAX (find the top item) online for free?
Open the free live spreadsheet on Cellgrids and try INDEX + MATCH + MAX (find the top item) yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts