Home › Practice questions › HLOOKUP › Question 4

Excel HLOOKUP Practice Question: Find the amount (quantity in B times the price from the table A1:C2). Put it…

By Rinkesh Shah, founder of Cellgrids.

The question

Find the amount (quantity in B times the price from the table A1:C2). Put it in C5 to C7.

The data

	A	B	C
1	Pen	Book	Bag
2	5	40	250
3
4	Item	Qty	Amount
5	Book	3	?
6	Bag	2	?
7	Pen	10	?

The yellow cells are where your answer goes.

Show answer

Expected results:

C5 = 120
C6 = 500
C7 = 50

How it works

Explanation: HLOOKUP finds the price in the table, and the price is multiplied by the quantity in the same row.
Syntax: =B5*HLOOKUP(A5,$A$1:$C$2,2,FALSE)
Book: 3 x 40 = 120. Bag: 2 x 250 = 500. Pen: 10 x 5 = 50.

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 →

HLOOKUP syntax

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Like VLOOKUP but searches across the first row and pulls a value down a column. Pulling a specific month's figure from a report laid out horizontally instead of in columns. Full HLOOKUP guide.