Place in the queue
A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Tickets are listed in the order they will be handled. Return the position of the ticket in E1 within the list. Answer in E2.
What this exercise teaches
MATCH returns a position, not a value. On its own it answers where something sits in a list, and inside INDEX it tells INDEX which row to return.
A hint if you get stuck
MATCH(value, range, 0) returns the position of the value in the range. The 0 asks for an exact match.
Try it now, free, no account needed
Your first 15 exercises on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.
Open this exerciseMore exercises in Lookups
- Find the price
- Stock on hand
- Look left with XLOOKUP
- A friendly "Not found"
- INDEX and MATCH
- Zero instead of #N/A
- Shipping rate by weight band
- Row and column lookup
- Latest status in a log
- Commission rate tier
- Targets laid out in a row
- Lookup by the start of a name
- Next sailing on or after a date
- Lookup on two keys
- Is the code on the list?