Excel HLOOKUP Practice Question: Look up the sales of each month in the table A1:E2. Put the results in B5 to B7.
The question
Look up the sales of each month in the table A1:E2. Put the results in B5 to B7.
The data
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Jan | Feb | Mar | Apr | May |
| 2 | 100 | 150 | 120 | 180 | 90 |
| 3 | |||||
| 4 | Month | Sales | |||
| 5 | Feb | ? | |||
| 6 | May | ? | |||
| 7 | Jan | ? |
The yellow cells are where your answer goes.
Show answer
Expected results:
- B5 = 150
- B6 = 90
- B7 = 100
How it works
Explanation: HLOOKUP looks for the month in the top row of the table and returns the value from the row number you give (2 here).
Syntax: =HLOOKUP(A5,$A$1:$E$2,2,FALSE)
Feb has 150. May has 90. Jan has 100.
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.
More HLOOKUP practice questions
- Look up the profit (the third row of the table A1:E3) of each month. Put the results in…
- The table A1:D2 gives the grade from the marks (0 is D, 50 is C, 75 is B, 90 is A). Find…
- Find the amount (quantity in B times the price from the table A1:C2). Put it in C5 to C7.
- Find the tax rate for each income with an approximate match on the table A1:D2 (the rate…
- Look up the sales of each month in A1:E2. If the month is not in the table write No…
- Add the sales of the From month and the To month, using the table A1:E2. Put the totals…
- Use the row number in column B (2 is Sales, 3 is Profit) to look up the month in the…
- Quarterly targets are in A1:E3, with quarters across the top. Find the Q3 target for the…
All practice questions · Excel exercises · Interview prep · Cheat sheet