Excel VLOOKUP Practice Question: Using VLOOKUP, find the marks of the roll number typed in E2 and put them in F2.
The question
Using VLOOKUP, find the marks of the roll number typed in E2 and put them in F2.
The data
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Roll | Name | Marks | Roll | Marks | |
| 2 | R-11 | Aman | 78 | R-13 | ? | |
| 3 | R-12 | Bhavna | 91 | |||
| 4 | R-13 | Chetan | 66 | |||
| 5 | R-14 | Divya | 85 |
The yellow cell is where your answer goes.
Show answer
Answer in F2: 66
How it works
Explanation: Always use FALSE for IDs and codes so Excel only accepts an exact match.
Syntax: =VLOOKUP(E2,A2:C5,3,FALSE)
R-13 is Chetan. Marks is the 3rd column, so the answer is 66.
Try it yourself in the live sheet
Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.
Try this question in the live sheet →VLOOKUP syntax
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Looks up a value in the first column of a range and returns a value from another column, same row. Pulling an employee's salary into another sheet using their ID. Full VLOOKUP guide.
More VLOOKUP practice questions
- Using VLOOKUP, find the price of the product code typed in E2 and put it in F2.
- Find the department of the employee ID typed in E2 and put it in F2.
- Using VLOOKUP with approximate match, find each student's grade from the band table in…
- Customer ID is typed in F1. Find that customer's name and city and put them in F2 and F3.
- Using VLOOKUP, fetch the unit price for each ordered product from the price list in…
- Find the total amount for each order (quantity times the unit price from the price list…
- Using VLOOKUP with MATCH to pick the column automatically, find the units for the…
- Using VLOOKUP with a wildcard, find the price of the first laptop in the list whose name…
All practice questions · Excel exercises · Interview prep · Cheat sheet