Lookup › MATCH35 / 67

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeMATCH

MATCH: find the stage order

The committee of an Independence Day karaoke contest in a Bekasi neighborhood has drawn the stage order. Fajar, the committee chair, keeps being asked "what number am I?", so he wants the number to appear automatically next to each name.

Task

Fill B2:B5 with each contestant's stage number, which is the position of their name in the draw result list D2:D9. Use MATCH with an exact match.

Cells to fillB2:B5

Required functionsMATCH

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
MATCH does not return a cell's content. It returns the position of a value inside a range.
Hint 2
The pattern is MATCH(search_value, range, 0). The 0 means it must match exactly.
Hint 3
Lock the draw list range with $: $D$2:$D$9.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

B2:B5

=MATCH(A2,$D$2:$D$9,0)

Write it in B2, then fill down to B5.

Explanation

=MATCH(A2,$D$2:$D$9,0) finds "Rina" at the 5th position of D2:D9, so the result is 5. The position counts from the start of the range, not from row 1 of the sheet. In Google Sheets the third argument of MATCH defaults to 1 (data assumed sorted ascending), so always write 0 for an unsorted list. MATCH is usually paired with INDEX to fetch data, as in the INDEX + MATCH exercise.

Starting worksheet: Sheet1
Row	A	B	D
1	Contestant	Stage order	Draw result
2	Rina		Fajar
3	Ayu		Ayu
4	Hendra		Gita
5	Dimas		Dimas
6			Rina
7			Bima
8			Lestari
9			Hendra
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result