Excel HLOOKUP Practice Question: Quarterly targets are in A1:E3, with quarters across the top. Find the Q3…
The question
Quarterly targets are in A1:E3, with quarters across the top. Find the Q3 target for the South row using HLOOKUP. Do not type the row number by hand: use 3 as the row index. Put it in G2.
The data
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Q4 | Result | |
| 2 | North | 120 | 135 | 150 | 165 | ? | |
| 3 | South | 90 | 100 | 115 | 130 |
The yellow cell is where your answer goes.
Show answer
Answer in G2: 115
How it works
Explanation: HLOOKUP searches across the first row and returns a value from the row number you choose. Row 3 of the table is the South row.
Syntax: =HLOOKUP("Q3",A1:E3,3,FALSE)
Q3 is in column D, and the South row gives 115.
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
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 sales of each month in the table A1:E2. Put the results in B5 to B7.
- 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…
All practice questions · Excel exercises · Interview prep · Cheat sheet