INDEX + MATCH + MIN (find the bottom item) Function in Excel: Syntax, Examples and Free Practice
INDEX + MATCH + MIN (find the bottom item) is an Excel Lookup & Reference function. Finds the lowest number in a range, then uses MATCH+INDEX to pull back the LABEL associated with it.
INDEX + MATCH + MIN (find the bottom item) syntax
Arguments
name_range: Range of labels/namesvalue_range: Range of numbers to find the min in
When to use INDEX + MATCH + MIN (find the bottom item)
Finding which product had the lowest rating, not just what the lowest score was.
Practice INDEX + MATCH + MIN (find the bottom item) online, free
Open the live Excel-style spreadsheet and try INDEX + MATCH + MIN (find the bottom item) yourself. No Excel install or sign-up needed to start.
Practice INDEX + MATCH + MIN (find the bottom item) now →More Lookup & Reference functions
Frequently asked questions
What does the INDEX + MATCH + MIN (find the bottom item) function do in Excel?
Finds the lowest number in a range, then uses MATCH+INDEX to pull back the LABEL associated with it.
What is the syntax of INDEX + MATCH + MIN (find the bottom item) in Excel?
The syntax is =INDEX(name_range, MATCH(MIN(value_range), value_range, 0)). name_range: Range of labels/names; value_range: Range of numbers to find the min in.
Where can I practice INDEX + MATCH + MIN (find the bottom item) online for free?
Open the free live spreadsheet on Cellgrids and try INDEX + MATCH + MIN (find the bottom 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