# INDEX & MATCH (Excel lesson 14 of 45)

> Look up by row and column at the same time.

Source: https://spreadsheetpractice.com/learn/index-match · Updated October 29, 2026

- **Course:** [Excel course](https://spreadsheetpractice.com/learn), track "Lookups"
- **Time:** about 10 minutes, 2 graded exercises
- **Functions:** `INDEX`, `MATCH`
- **Access:** Pro (the lesson text is free; the graded exercises need Pro)
- **Key formula:** `=MATCH(H2,A2:A6,0)`: Position of the zone

## How it works

`MATCH(value, list, 0)` returns the position of a value in a list: Zone 3 is in position 3. `INDEX(range, row, column)` returns whatever sits at that position.

Use one MATCH for the row and another for the column, and you have a two-way lookup that works in every version of Excel.

## Syntax

| Formula | What it does |
|---|---|
| `=MATCH(H2,A2:A6,0)` | Position of the zone |
| `=INDEX(B2:E6,3,3)` | Row 3, column 3 of the grid |
| `=INDEX(B2:E6,MATCH(H2,A2:A6,0),MATCH(H3,B1:E1,0))` | Two-way lookup |

## Watch out for

- MATCH needs 0 as its last argument for an exact match; without it, it assumes sorted data.
- INDEX counts from the first cell of its own range, not from row 1 of the sheet.

## The exercises

Solve them in the live grid at [INDEX & MATCH](https://spreadsheetpractice.com/learn/index-match). Each answer is graded, then re-checked on changed data so typed-in numbers don't pass.

1. **Find the position.** Next to "Zone position", in H5, return the position of the zone from H2 within A2:A6.
2. **Two-way lookup.** Next to "Rate", in H6, return the shipping rate for the zone in H2 and the weight in H3.

Previous: [XLOOKUP](https://spreadsheetpractice.com/learn/xlookup) · Next: [Tiered lookups & IFERROR](https://spreadsheetpractice.com/learn/tiered-lookups-iferror)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
