Lookup & reference › INDEX80 / 144

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

EasyFreeINDEX

INDEX: who holds the winning number?

The organizers of an Independence Day fun walk at a housing estate in Cikarang are drawing door prizes. Participants are listed in order of their coupon numbers, 1 to 10. The numbers drawn are typed into E2, E3 and E4.

Task

Fill F2:F4 with the winner's name for each coupon number in E2:E4. The coupon number equals the participant's position in the list B2:B11. Use INDEX.

Cells to fillF2:F4

Required functionsINDEX

Expected result

Loading the expected result…

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

Hint 1
INDEX(range, position) returns the item at a given position in the range. For example, INDEX(B2:B11, 1) is the content of B2.
Hint 2
The position is in E2. Lock the name list as $B$2:$B$11 before copying the formula down.
Hint 3
Pattern: =INDEX($B$2:$B$11, …).

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

=INDEX($B$2:$B$11,E2)

Write it in F2, then fill down to F4.

Explanation

=INDEX($B$2:$B$11,E2) returns the 7th, 2nd and 10th names in the list. INDEX counts positions from the start of the range, not sheet row numbers: position 1 is B2, not B1. A number outside 1 to 10 gives #REF!. INDEX is most useful paired with MATCH, which finds the position for you.

Starting worksheet: Sheet1
Row	A	B	E	F
1	Coupon no.	Participant	Number drawn	Winner
2	1	Pak Darto	7
3	2	Bu Wati	2
4	3	Reza	10
5	4	Mbak Yuni
6	5	Om Joko
7	6	Tante Lina
8	7	Kevin
9	8	Ibu Endang
10	9	Bayu
11	10	Kak Nadia
12
13
14

Fill in the requested cell, then press Check answer.

Validation result