Course
INDEX + MATCH practice exercises
Five exercises, from MATCH on its own to a two-way lookup. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Read the INDEX + MATCH tutorial
Exercise 1 of 5
Find a store’s position in the list
In F2, write a MATCH that returns the position of the store in E2 within the list B2:B9.
| Store ID | Store | Sales ($) | Store | Position | |
| 208 | Denver | 48,200.00 | Chicago | ||
| 415 | Boston | 61,750.00 | |||
| 133 | Seattle | 39,400.00 | |||
| 362 | Austin | 72,300.00 | |||
| 527 | Chicago | 55,900.00 | |||
| 291 | Miami | 44,100.00 | |||
| 446 | Portland | 67,800.00 | |||
| 174 | Atlanta | 52,600.00 |