Exercises / Lookups · 3 of 10
Read a row-based table with HLOOKUP
HLOOKUP is VLOOKUP turned sideways: it searches the top row of a table and returns a value from a row below it.
Your taskIn H2, use HLOOKUP to return the profit for the quarter named in H1, from the table A1:E4. Ask for an exact match.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|---|
| 1 | Q1 | Q2 | Q3 | Q4 | Quarter | Q2 | ||
| 2 | Revenue | $182,000.00 | $201,500.00 | $195,300.00 | $238,900.00 | Profit | ||
| 3 | Costs | $139,400.00 | $148,200.00 | $151,000.00 | $170,600.00 | |||
| 4 | Profit | $42,600.00 | $53,300.00 | $44,300.00 | $68,300.00 |