Course
MATCH practice exercises
Five exercises, from an exact position to approximate match on a band table. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 5
Find an order’s place in the queue
The print queue in A1:C9 is listed in the order the jobs will run. In F2, write a MATCH that returns the position of the order number in E2 within A2:A9.
| Order no. | Customer | Amount ($) | Order no. | Position | |
| 1042 | Bluebird Café | 240.00 | 1048 | ||
| 1057 | Harbor Books | 86.50 | |||
| 1039 | Maple Dental | 1,320.00 | |||
| 1061 | Summit Gym | 415.00 | |||
| 1048 | Pine Street Bakery | 58.00 | |||
| 1053 | Copper Kettle Deli | 730.00 | |||
| 1066 | Riverside Garage | 192.40 | |||
| 1044 | Oak & Ivy Florist | 365.00 |