Question 1 of 10
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | STATE | 2020 | 2021 | 2022 | 2023 | 2024 |
| 2 | New York | 12 | 16 | 18 | 17 | 22 |
| 3 | Wisconsin | 2 | 5 | 4 | 5 | 6 |
| 4 | Texas | 8 | 7 | 8 | 8 | 9 |
| 5 | Ohio | 4 | 4 | 7 | 6 | 12 |
HLOOKUP Function 2 - Free Excel Practice Online
This free, interactive exercise teaches you HLOOKUP Function 2 in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Lookup Functions track and works right in your browser - no Excel install, no download, and no signup.
Practising HLOOKUP Function 2 this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.
What you'll practice in this HLOOKUP Function 2 lesson
- What would =HLOOKUP(2022, 1:5, 4, FALSE) return?
- Write an HLOOKUP that returns Wisconsin sales for 2021. Use exact matching (4th argument is FALSE) and use rows 1 through 5 as the lookup range (1:5).
- What would =HLOOKUP(2024, 1:5, 1, FALSE) return?
- Write an HLOOKUP that returns Ohio sales for 2024. Use exact matching (4th argument is FALSE) and use rows 1 through 5 as the lookup range (1:5).
- What would =HLOOKUP("STATE", 1:5, 5, FALSE) return?
- Write an HLOOKUP that returns Wisconsin sales for 2023. Use exact matching (4th argument is FALSE) and use rows 1 through 5 as the lookup range (1:5).
- What would =HLOOKUP(2020, 1:5, 2, FALSE) return?
- Write an HLOOKUP that returns New York sales for 2021. Use exact matching (4th argument is FALSE) and use rows 1 through 5 as the lookup range (1:5).
- What would =HLOOKUP(2023, 1:5, 4, FALSE) return?
- Write an HLOOKUP that returns Texas sales for 2024. Use exact matching (4th argument is FALSE) and use rows 1 through 5 as the lookup range (1:5).
HLOOKUP Function 2 practice - FAQ
How do I practice HLOOKUP Function 2 in Excel?
Open this free LogicExcel exercise and work through 10 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation - no Excel install and no signup needed.
Is the HLOOKUP Function 2 exercise free?
Yes. Every LogicExcel exercise is 100% free with no account required. Your progress saves automatically in your browser.
What will I learn in this HLOOKUP Function 2 lesson?
This lesson covers HLOOKUP Function 2 as part of the Lookup Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.