HLOOKUP Function in Excel: Syntax, Examples and Free Practice
HLOOKUP is an Excel Lookup & Reference function. Like VLOOKUP but searches across the first row and pulls a value down a column.
HLOOKUP syntax
Arguments
lookup_value: Value to search for in the top rowtable_array: Range containing the datarow_index_num: Which row (from the top) to pull the result fromrange_lookup: FALSE for exact match
When to use HLOOKUP
Pulling a specific month's figure from a report laid out horizontally instead of in columns.
Practice HLOOKUP online, free
Solve graded HLOOKUP practice questions in a live Excel-style spreadsheet and check your answer instantly.
Practice HLOOKUP now →Learn more
Read the tutorial: How to use HLOOKUP.
HLOOKUP practice questions
- Look up the sales of each month in the table A1:E2. Put the results in B5 to B7.
- Look up the profit (the third row of the table A1:E3) of each month. Put the results in…
- The table A1:D2 gives the grade from the marks (0 is D, 50 is C, 75 is B, 90 is A). Find…
- Find the amount (quantity in B times the price from the table A1:C2). Put it in C5 to C7.
- Find the tax rate for each income with an approximate match on the table A1:D2 (the rate…
- Look up the sales of each month in A1:E2. If the month is not in the table write No…
- Add the sales of the From month and the To month, using the table A1:E2. Put the totals…
- Use the row number in column B (2 is Sales, 3 is Profit) to look up the month in the…
- Quarterly targets are in A1:E3, with quarters across the top. Find the Q3 target for the…
More Lookup & Reference functions
Frequently asked questions
What does the HLOOKUP function do in Excel?
Like VLOOKUP but searches across the first row and pulls a value down a column.
What is the syntax of HLOOKUP in Excel?
The syntax is =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]). lookup_value: Value to search for in the top row; table_array: Range containing the data; row_index_num: Which row (from the top) to pull the result from; range_lookup: FALSE for exact match.
Where can I practice HLOOKUP online for free?
Open the free live spreadsheet on Cellgrids and try HLOOKUP yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts