INDEX + MATCH (2-way lookup) Function in Excel: Syntax, Examples and Free Practice
INDEX + MATCH (2-way lookup) is an Excel Lookup & Reference function. Uses two MATCH functions inside one INDEX to look up a value at the intersection of a specific row AND column — a 2D lookup.
INDEX + MATCH (2-way lookup) syntax
Arguments
data_range: The full table of valuesrow_value: Value to find among the row labelscol_value: Value to find among the column labels
When to use INDEX + MATCH (2-way lookup)
Looking up a specific product's sales figure for a specific month from a table with products as rows and months as columns.
Practice INDEX + MATCH (2-way lookup) online, free
Open the live Excel-style spreadsheet and try INDEX + MATCH (2-way lookup) yourself. No Excel install or sign-up needed to start.
Practice INDEX + MATCH (2-way lookup) now →More Lookup & Reference functions
Frequently asked questions
What does the INDEX + MATCH (2-way lookup) function do in Excel?
Uses two MATCH functions inside one INDEX to look up a value at the intersection of a specific row AND column — a 2D lookup.
What is the syntax of INDEX + MATCH (2-way lookup) in Excel?
The syntax is =INDEX(data_range, MATCH(row_value, row_labels, 0), MATCH(col_value, col_labels, 0)). data_range: The full table of values; row_value: Value to find among the row labels; col_value: Value to find among the column labels.
Where can I practice INDEX + MATCH (2-way lookup) online for free?
Open the free live spreadsheet on Cellgrids and try INDEX + MATCH (2-way lookup) 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