Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
INDEX with two MATCHes. INDEX(grid, row, column) returns one cell of a grid. Let one MATCH find the row (search the labels down the side) and another find the column (search the headers along the top). Both MATCH ranges must line up with the grid’s first row and first column.
=INDEX($B$2:$H$9,MATCH(K2,$A$2:$A$9,0),MATCH(L2,$B$1:$H$1,0)) a room’s price for a weekday
The regional managers sent a list of month-and-region pairs they want the H1 revenue target for. The targets sit in a grid: months down the side, regions across the top.
In I2:I6, return the target from the grid B2:E7 for the region in column G and the month in column H. Find the row with the month in A2:A7 and the column with the region in B1:E1. Write it once in I2 and fill down.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Month | North | South | East | West | Region | Month | Target | |
| 2 | 2025-01-01 | 6,310 | 8,929 | 5,314 | 11,581 | West | 2025-03-01 | ||
| 3 | 2025-02-01 | 6,663 | 8,933 | 5,186 | 11,636 | North | 2025-06-01 | ||
| 4 | 2025-03-01 | 6,413 | 8,907 | 5,542 | 11,255 | East | 2025-01-01 | ||
| 5 | 2025-04-01 | 6,847 | 8,558 | 4,893 | 11,503 | South | 2025-04-01 | ||
| 6 | 2025-05-01 | 6,757 | 8,684 | 5,655 | 11,159 | East | 2025-05-01 | ||
| 7 | 2025-06-01 | 6,329 | 8,553 | 4,827 | 11,748 | ||||
| 8 | |||||||||
| 9 | |||||||||
| 10 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe