Course
HLOOKUP practice exercises
Five exercises, from your first HLOOKUP to a table filled down with $. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 5
Find a budget for one month
In B7, write an HLOOKUP that returns the Groceries budget for April, using the budget in A1:G5. The months run across row 1.
| Category | January | February | March | April | May | June |
| Rent | 1,200.00 | 1,200.00 | 1,200.00 | 1,250.00 | 1,250.00 | 1,250.00 |
| Groceries | 410.00 | 385.00 | 432.00 | 398.00 | 420.00 | 445.00 |
| Transport | 95.00 | 110.00 | 88.00 | 120.00 | 102.00 | 97.00 |
| Utilities | 180.00 | 165.00 | 150.00 | 128.00 | 112.00 | 104.00 |
| Groceries in April |