Lookup Functions
Intermediate
Basic HLOOKUP Function
Use HLOOKUP to find values in a horizontally arranged table.
Task:
You have sales data arranged horizontally by quarter. Use HLOOKUP to find the sales value for a specific region and quarter combination.
Learning Objectives:
- Learn HLOOKUP function
- Understand horizontal data arrangement
- Practice cross-referencing data
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Q1 | Q2 | Q3 | Q4 | |
| 2 | North | 25000 | 28000 | 30000 | 32000 |
| 3 | South | 22000 | 24000 | 26000 | 28000 |
| 4 | East | 20000 | 23000 | 25000 | 27000 |
| 5 | West | 18000 | 21000 | 24000 | 26000 |
| 6 | |||||
| 7 | Region | Quarter | Sales | ||
| 8 | North | Q3 | |||
| 9 | South | Q2 | |||
| 10 | East | Q4 |
What this exercise teaches (contains the answer)
HLOOKUP works like VLOOKUP but searches horizontally across the first row instead of vertically down the first column.