Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
INDEX / MATCH
INDEX returns a value at a position; MATCH finds that position. Combined, they look up in any direction and outperform VLOOKUP on large sheets.
Topic:INDEX / MATCHExcel
=INDEX(B:B, MATCH(D2, A:A, 0))Google Sheets
=INDEX(B:B, MATCH(D2, A:A, 0))Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1MATCH(D2, A:A, 0) finds the row where A equals D2.
- 2INDEX(B:B, …) returns the value from B in that row.
- 30 in MATCH means exact match.
More on INDEX / MATCH
See all →How-to
How to do a two-way lookup
Use INDEX with two MATCH functions to look up a value at the intersection of a matching row and a matching column.
Error fixFix #N/A
Fix #N/A errors in INDEX MATCH in Excel and Google Sheets — match_type wrong, arrays different sizes, data-type mismatches, and lookup value absent.
How-toHow to use INDEX MATCH with two criteria
Combine INDEX and MATCH with multiplication of two criteria arrays to perform a lookup that matches on two conditions simultaneously.
How-toHow to do a two-dimensional lookup
Combine INDEX with two MATCH calls — one for the row and one for the column — to look up a value at the intersection of a row and column header.