Home › Practice questions › HLOOKUP › Question 7

Excel HLOOKUP Practice Question: Add the sales of the From month and the To month, using the table A1:E2. Put…

By Rinkesh Shah, founder of Cellgrids.

The question

Add the sales of the From month and the To month, using the table A1:E2. Put the totals in C5 to C7.

The data

	A	B	C	D	E
1	Jan	Feb	Mar	Apr	May
2	100	150	120	180	90
3
4	From	To	Total
5	Jan	Mar	?
6	Feb	Apr	?
7	Mar	May	?

The yellow cells are where your answer goes.

Show answer

Expected results:

C5 = 220
C6 = 330
C7 = 210

How it works

Explanation: Two HLOOKUPs find the sales of the two months, and the + sign adds them.
Syntax: =HLOOKUP(A5,$A$1:$E$2,2,FALSE)+HLOOKUP(B5,$A$1:$E$2,2,FALSE)
Jan + Mar = 100 + 120 = 220. Feb + Apr = 150 + 180 = 330. Mar + May = 120 + 90 = 210.

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.