Lookup & reference › MATCH81 / 144

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

EasyFreeMATCH

MATCH: a team's position in the standings

The organizers of an inter-village volleyball league in Kudus have sorted the standings from the most points down. Team captains keep asking "what position are we in?", so the organizers want the answer to appear automatically.

Task

Fill F2:F4 with the position of each team in E2:E4 within the standings list A2:A9. Use MATCH with an exact match.

Cells to fillF2:F4

Required functionsMATCH

Expected result

Loading the expected result…

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

Hint 1
MATCH(lookup_value, range, 0) returns the position of the value within the range, not the value itself. The 0 means it must match exactly.
Hint 2
Lock the standings range as $A$2:$A$9, then copy the formula down.
Hint 3
Pattern: =MATCH(E2, …, 0).

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

F2:F4

=MATCH(E2,$A$2:$A$9,0)

Write it in F2, then fill down to F4.

Explanation

=MATCH(E2,$A$2:$A$9,0) returns 4 for Karya Utama because that team is fourth in the list. The standings are already sorted by points, so the position in the list equals the rank. Without the third argument, MATCH uses type 1 (approximate), which needs ascending data, so make a habit of writing 0. MATCH ignores upper and lower case: "garuda" still finds "Garuda".

Starting worksheet: Sheet1
Row	A	B	C	E	F
1	Team	Played	Points	Team	Position
2	Bintang Muda	7	16	Karya Utama
3	Garuda	7	14	Garuda
4	Putra Jati	7	13	Rajawali
5	Karya Utama	7	11
6	Sinar Kulon	7	9
7	Pelita Wetan	7	7
8	Tunas Harapan	7	4
9	Rajawali	7	2
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result