Home › Practice questions › VLOOKUP › Question 1

Excel VLOOKUP Practice Question: Using VLOOKUP, find the price of the product code typed in E2 and put it in F2.

By Rinkesh Shah, founder of Cellgrids.

The question

Using VLOOKUP, find the price of the product code typed in E2 and put it in F2.

The data

	A	B	C	E	F
1	Code	Product	Price	Code	Price
2	P-101	Pen	12	P-104	?
3	P-102	Book	85
4	P-103	Bag	640
5	P-104	Marker	25
6	P-105	Folder	40
7	P-106	Stapler	110

The yellow cell is where your answer goes.

Show answer

Answer in F2: 25

How it works

Explanation: VLOOKUP searches the first column of a table for a value and returns something from another column in the same row. FALSE means exact match.
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, FALSE)
E2 is P-104, which is the Marker row. Price is the 3rd column of the table, so the answer 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.