INDEX practice exercises
Returns the value at a position in a range. Work through these on the table below, then check each answer.
Practise interactively Type formulas into a live sheet with instant feedback. Free.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Rep | Units | Price | Revenue |
| 2 | 2501 | East | Ana | 8 | 24 | 192 |
| 3 | 2502 | West | Kofi | 3 | 12 | 36 |
| 4 | 2503 | East | Ana | 5 | 60 | 300 |
| 5 | 2504 | North | Maya | 7 | 12 | 84 |
| 6 | 2505 | South | Ana | 9 | 24 | 216 |
| 7 | 2506 | East | Kofi | 9 | 45 | 405 |
| 8 | 2507 | West | Raj | 5 | 12 | 60 |
| 9 | 2508 | East | Kofi | 1 | 15 | 15 |
Use INDEX and MATCH to return the Units for order 2505.
Show answer
=INDEX(D2:D9,MATCH(2505,A2:A9,0))→ 9Use INDEX and MATCH to return the Units for order 2501.
Show answer
=INDEX(D2:D9,MATCH(2501,A2:A9,0))→ 8Use INDEX and MATCH to return the Units for order 2507.
Show answer
=INDEX(D2:D9,MATCH(2507,A2:A9,0))→ 5Use INDEX and MATCH to return the Units for order 2503.
Show answer
=INDEX(D2:D9,MATCH(2503,A2:A9,0))→ 5Use INDEX and MATCH to return the Units for order 2502.
Show answer
=INDEX(D2:D9,MATCH(2502,A2:A9,0))→ 3Use INDEX and MATCH to return the Units for order 2508.
Show answer
=INDEX(D2:D9,MATCH(2508,A2:A9,0))→ 1
New to INDEX? Read the INDEX guide first: syntax, a worked example and common mistakes.