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.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of HLOOKUP
0/3The same formula in the other shapes it takes at work.
- Basic HLOOKUP Function
Use HLOOKUP to find values in a horizontally arranged table.
CoreIntermediate - HLOOKUP from a table laid out sideways
When the keys run along the top, look across instead of down.
Beginner - HLOOKUP approximate match with two rate rows
Weight bands across the top, one row per service — pick the band and the row.
Advanced
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 |
Functions used here
What this exercise teachesMay contain the answer
HLOOKUP works like VLOOKUP but searches horizontally across the first row instead of vertically down the first column.