MATCH practice exercises
Returns the position of a value in a list. 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 | 6901 | North | Omar | 6 | 12 | 72 |
| 3 | 6902 | East | Lena | 5 | 15 | 75 |
| 4 | 6903 | South | Kofi | 3 | 45 | 135 |
| 5 | 6904 | West | Kofi | 8 | 12 | 96 |
| 6 | 6905 | West | Lena | 8 | 18 | 144 |
| 7 | 6906 | East | Ana | 6 | 60 | 360 |
| 8 | 6907 | West | Ana | 6 | 12 | 72 |
| 9 | 6908 | East | Kofi | 7 | 12 | 84 |
In which position of the Order list is order 6905?
Show answer
=MATCH(6905,A2:A9,0)→ 5In which position of the Order list is order 6908?
Show answer
=MATCH(6908,A2:A9,0)→ 8In which position of the Order list is order 6902?
Show answer
=MATCH(6902,A2:A9,0)→ 2In which position of the Order list is order 6904?
Show answer
=MATCH(6904,A2:A9,0)→ 4In which position of the Order list is order 6901?
Show answer
=MATCH(6901,A2:A9,0)→ 1In which position of the Order list is order 6906?
Show answer
=MATCH(6906,A2:A9,0)→ 6
New to MATCH? Read the MATCH guide first: syntax, a worked example and common mistakes.