Home › Practice questions › VLOOKUP › Question 6

Excel VLOOKUP Practice Question: Using VLOOKUP, fetch the unit price for each ordered product from the price…

By Rinkesh Shah, founder of Cellgrids.

The question

Using VLOOKUP, fetch the unit price for each ordered product from the price list in E2:F6 and put it in C2 to C5.

The data

	A	B	C	E	F
1	Product	Qty	Price	Product	Price
2	Pen	10	?	Pen	12
3	Bag	2	?	Book	85
4	Book	5	?	Bag	640
5	Marker	8	?	Marker	25
6				Folder	40

The yellow cells are where your answer goes.

Show answer

Expected results:

C2 = 12
C3 = 640
C4 = 85
C5 = 25

How it works

Explanation: Lock the price list with $ so it stays in place as you copy the formula down. The lookup value moves to the next product each time.
Syntax: =VLOOKUP(A2,$E$2:$F$6,2,FALSE)
Pen is 12, Bag is 640, Book is 85 and Marker is 25.

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.