Home › Practice questions › HLOOKUP › Question 2

Excel HLOOKUP Practice Question: Look up the profit (the third row of the table A1:E3) of each month. Put the…

By Rinkesh Shah, founder of Cellgrids.

The question

Look up the profit (the third row of the table A1:E3) of each month. Put the results in B6 to B8.

The data

	A	B	C	D	E
1	Jan	Feb	Mar	Apr	May
2	100	150	120	180	90
3	20	30	25	40	15
4
5	Month	Profit
6	Mar	?
7	Apr	?
8	Jan	?

The yellow cells are where your answer goes.

Show answer

Expected results:

B6 = 25
B7 = 40
B8 = 20

How it works

Explanation: The row index 3 tells HLOOKUP to return the value from the third row of the table.
Syntax: =HLOOKUP(A6,$A$1:$E$3,3,FALSE)
Mar has a profit of 25. Apr has 40. Jan has 20.

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.