INDEX + MATCH Function in Excel: Syntax, Examples and Free Practice
INDEX + MATCH is an Excel Lookup & Reference function. Combines INDEX and MATCH to look up a value — more flexible than VLOOKUP since it can look left and doesn't break if columns are inserted.
INDEX + MATCH syntax
Arguments
return_range: Range containing the value to returnlookup_value: Value to search forlookup_range: Range to search in
When to use INDEX + MATCH
Looking up a price when the lookup column is to the right of the price column (something VLOOKUP can't do).
Practice INDEX + MATCH online, free
Open the live Excel-style spreadsheet and try INDEX + MATCH yourself. No Excel install or sign-up needed to start.
Practice INDEX + MATCH now →More Lookup & Reference functions
Frequently asked questions
What does the INDEX + MATCH function do in Excel?
Combines INDEX and MATCH to look up a value — more flexible than VLOOKUP since it can look left and doesn't break if columns are inserted.
What is the syntax of INDEX + MATCH in Excel?
The syntax is =INDEX(return_range, MATCH(lookup_value, lookup_range, 0)). return_range: Range containing the value to return; lookup_value: Value to search for; lookup_range: Range to search in.
Where can I practice INDEX + MATCH online for free?
Open the free live spreadsheet on Cellgrids and try INDEX + MATCH 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