Practice problems Excel free download for HLOOKUP function with 20 examples and solutions

What is HLOOKUP in Excel – Practice Problems Excel Free Download

Boost your Excel skills with this practice problems Excel free download for HLOOKUP. Unlike VLOOKUP, which searches vertically, HLOOKUP works horizontally across the top row of a table and retrieves values from a specified row below. This guide provides step-by-step exercises, formulas, and solutions to help you master horizontal lookups efficiently.

You can also download the HLOOKUP Excel exercises file to try all examples directly in Excel.

Download HLOOKUP Excel Workbook

Sample Dataset for HLOOKUP

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

EmpID101102103104105106
NameAlice LeeBob SmithCarla GomezDavid ChenEmma DavisFrank Wright
DeptHRITFinanceSalesMarketingIT
Salary500006000055000720006200058000
LocationNew YorkLondonTorontoSydneyBerlinChicago
Bonus %10%12%9%15%11%13%

10 HLOOKUP Practice Problems with Solutions – Excel Free Download

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.

How HLOOKUP Formulas Work

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.