Sheetsdrill

Level 3: Lookups Exercise 50 of 92

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.

Functions used: 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 exercise

More exercises in Lookups