INDEX + MATCH (multiple criteria) Function in Excel: Syntax, Examples and Free Practice
INDEX + MATCH (multiple criteria) is an Excel Lookup & Reference function. Uses an array-style MATCH to find a row that satisfies two conditions at once, then returns a value from that row.
INDEX + MATCH (multiple criteria) syntax
Arguments
return_range: Range to pull the result fromcriteria1_range: First range to checkcriteria2_range: Second range to check
When to use INDEX + MATCH (multiple criteria)
Finding a specific employee's salary by matching both their name AND department.
Practice INDEX + MATCH (multiple criteria) online, free
Open the live Excel-style spreadsheet and try INDEX + MATCH (multiple criteria) yourself. No Excel install or sign-up needed to start.
Practice INDEX + MATCH (multiple criteria) now →More Lookup & Reference functions
Frequently asked questions
What does the INDEX + MATCH (multiple criteria) function do in Excel?
Uses an array-style MATCH to find a row that satisfies two conditions at once, then returns a value from that row.
What is the syntax of INDEX + MATCH (multiple criteria) in Excel?
The syntax is =INDEX(return_range, MATCH(1, (criteria1_range=criteria1)*(criteria2_range=criteria2), 0)). return_range: Range to pull the result from; criteria1_range: First range to check; criteria2_range: Second range to check.
Where can I practice INDEX + MATCH (multiple criteria) online for free?
Open the free live spreadsheet on Cellgrids and try INDEX + MATCH (multiple criteria) 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