Level 3ModelingPractice, 3 min
Two-way lookup: row and column
The task
In H3, return the revenue target for the region in H1 and the quarter in H2. One MATCH finds the row, another finds the column, and INDEX returns where they cross.
The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Q4 | Region | East | |
| 2 | North | $410,000 | $435,000 | $460,000 | $520,000 | Quarter | Q3 | |
| 3 | South | $380,000 | $395,000 | $405,000 | $450,000 | Target | ||
| 4 | East | $520,000 | $540,000 | $575,000 | $640,000 | |||
| 5 | West | $610,000 | $625,000 | $660,000 | $735,000 | |||
| 6 | Central | $290,000 | $300,000 | $310,000 | $345,000 |