HLOOKUP Practice Exercises XLS Download + Solutions

What is HLOOKUP in Excel?

If you’re learning Excel, you’ve probably mastered VLOOKUP already. But what about HLOOKUP?
The HLOOKUP function is just like VLOOKUP, except it searches horizontally across the first row of a table and returns a value from a specified row below.

In this guide, we’ll walk through HLOOKUP practice exercises with data, formulas, and solutions. Plus, you can get the HLOOKUP practice exercises XLS download to try it yourself in Excel.

Sample Data for HLOOKUP

Here’s the dataset we’ll use (arranged horizontally, since HLOOKUP works across rows):

EmpID	101	102	103	104	105	106
Name	Alice Lee	Bob Smith	Carla Gomez	David Chen	Emma Davis	Frank Wright
Dept	HR	IT	Finance	Sales	Marketing	IT
Salary	50000	60000	55000	72000	62000	58000
Location	New York	London	Toronto	Sydney	Berlin	Chicago
Bonus %	10%	12%	9%	15%	11%	13%

HLOOKUP Practice Problems

Try these on your own before peeking at the answers:

1. Find the Name of EmpID 104.
2. Find the Department of EmpID 103.
3. Get the Salary of EmpID 106.
4. Which Location does EmpID 102 belong to?
5. What is the Bonus % of EmpID 101?
6. Find the Salary of EmpID 105.
7. Get the Department of EmpID 106.
8. Find the Name of EmpID 101.
9. Calculate Total Compensation (Salary + Bonus%) of EmpID 104.
10. Use HLOOKUP with FALSE to check if EmpID 107 exists.

Solutions with Formulas

Here’s how you can solve them using HLOOKUP:

1. =HLOOKUP(104, B1:G6, 2, FALSE) → David Chen
2. =HLOOKUP(103, B1:G6, 3, FALSE) → Finance
3. =HLOOKUP(106, B1:G6, 3, FALSE) → 58000
4. =HLOOKUP(102, B1:G6, 4, FALSE) → London
5. =HLOOKUP(101, B1:G6, 5, FALSE) → 10%
6. =HLOOKUP(105, B1:G6, 3, FALSE) → 62000
7. =HLOOKUP(106, B1:G6, 3, FALSE) → 58000
8. =HLOOKUP(101, B1:G6, 2, FALSE) → Alice Lee
9. =HLOOKUP(104,B1:G6,3,FALSE)*(1+HLOOKUP(104,B1:G6,5,FALSE)) → 82,800
10. =HLOOKUP(107,B1:G6,2,FALSE) → #N/A (does not exist)

What This Template Teaches

This HLOOKUP practice exercises XLS download helps you learn to:

• Use HLOOKUP to retrieve values horizontally.
• Apply exact match searches (FALSE).
• Combine HLOOKUP with math to calculate totals.
• Handle missing data (#N/A cases).

---

Ready to start? Download the free practice file here and begin mastering HLOOKUP today.