Question 1 of 10
The first argument is the search value, the second argument is the range to search, the third argument is how many rows down to search from the lookup value, and the fourth argument is whether to use approximate match.
To get the value in the 3rd row where the value in the first row is "Clinton" we would write
=HLOOKUP("Clinton", A1:G3, 3, false)
What would this formula return?
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | President: | Trump | Obama | Bush Jr. | Clinton | Bush Sr. | Reagan | Carter |
| 2 | Year Elected: | 2016 | 2008 | 2000 | 1992 | 1988 | 1980 | 1976 |
| 3 | Years in Office: | 4 | 8 | 8 | 8 | 4 | 8 | 4 |
| 4 | ||||||||
| 5 |
HLOOKUP Function - Free Excel Practice Online
This free, interactive exercise teaches you HLOOKUP Function 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 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 lesson
- The HLOOKUP function in Excel is similar to VLOOKUP, but instead of searching a vertical list and returning a value from a corresponding column, it instead searches a horizontal list and returns a value from a corresponding row.The first argument is the search value, the second argument is the range to search, the third argument is how many rows down to search from the lookup value, and the fourth argument is whether to use approximate match.To get the value in the 3rd row where the value in the first row is "Clinton" we would write=HLOOKUP("Clinton", A1:G3, 3, false)What would this formula return?
- What would =HLOOKUP("Trump", A1:G3, 3, false) return?
- What would =HLOOKUP("Bush Jr.", A1:G3, 2, false) return?
- What would =HLOOKUP("Obama", A1:G3, 1, false) return?
- Write an HLOOKUP formula that returns the year Reagan was elected. Use exact match (4th argument should be false). Use the range A1:G3.
- Write an HLOOKUP formula that returns the number of years Trump was in office. Use exact match (4th argument should be false). Use the range A1:G3.
- Write an HLOOKUP formula that returns the number of years Clinton was in office. Use exact match (4th argument should be false). Use the range A1:G3.
- What would =HLOOKUP("Obama", A1:G3, 3, false) return?
- What would =HLOOKUP("Bush Sr.", A1:G3, 2, false) return?
- What would =HLOOKUP("Bush Sr.", A1:G3, 3, false) return?
HLOOKUP Function practice - FAQ
How do I practice HLOOKUP Function 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 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 lesson?
This lesson covers HLOOKUP Function as part of the Lookup Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.