Home › Practice questions › VLOOKUP › Question 11

Excel VLOOKUP Practice Question: Orders are in A2:B7 and the price list is in D2:E6. Find the unit price for…

By Rinkesh Shah, founder of Cellgrids.

The question

Orders are in A2:B7 and the price list is in D2:E6. Find the unit price for each order in G2:G7 with VLOOKUP (exact match).

The data

	A	B	D	E	G
1	Product ID	Qty	Product ID	Unit price	Order price
2	P-103	4	P-101	450	?
3	P-101	2	P-102	1250	?
4	P-105	1	P-103	299	?
5	P-102	3	P-104	780	?
6	P-104	5	P-105	2150	?
7	P-101	6			?

The yellow cells are where your answer goes.

Show answer

Expected results:

G2 = 299
G3 = 450
G4 = 2150
G5 = 1250
G6 = 780
G7 = 450

How it works

Explanation: VLOOKUP looks for the product ID in the first column of the price list and returns the value from column 2. FALSE forces an exact match, and the dollar signs keep the list fixed when you fill down.
Syntax: =VLOOKUP(A2,$D$2:$E$6,2,FALSE)
P-103 gives 299, P-101 gives 450, P-105 gives 2150, and so on.

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.