VLOOKUP practice exercises
Finds a row by its first column and returns another column. Work through these on the table below, then check each answer.
Practise interactively Type formulas into a live sheet with instant feedback. Free.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Rep | Units | Price | Revenue |
| 2 | 3801 | North | Ines | 6 | 30 | 180 |
| 3 | 3802 | North | Kofi | 2 | 60 | 120 |
| 4 | 3803 | North | Kofi | 5 | 60 | 300 |
| 5 | 3804 | South | Ines | 7 | 18 | 126 |
| 6 | 3805 | West | Ines | 7 | 9 | 63 |
| 7 | 3806 | North | Maya | 1 | 45 | 45 |
| 8 | 3807 | South | Omar | 1 | 9 | 9 |
| 9 | 3808 | East | Ines | 2 | 12 | 24 |
Use VLOOKUP to find the Revenue for order 3805.
Show answer
=VLOOKUP(3805,A2:F9,6,FALSE)→ 63Use VLOOKUP to find the Region for order 3805.
Show answer
=VLOOKUP(3805,A2:F9,2,FALSE)→ WestUse VLOOKUP to find the Rep for order 3802.
Show answer
=VLOOKUP(3802,A2:F9,3,FALSE)→ KofiUse VLOOKUP to find the Rep for order 3807.
Show answer
=VLOOKUP(3807,A2:F9,3,FALSE)→ OmarUse VLOOKUP to find the Revenue for order 3808.
Show answer
=VLOOKUP(3808,A2:F9,6,FALSE)→ 24Use VLOOKUP to find the Rep for order 3805.
Show answer
=VLOOKUP(3805,A2:F9,3,FALSE)→ Ines
New to VLOOKUP? Read the VLOOKUP guide first: syntax, a worked example and common mistakes.