HLOOKUP in Excel: Formula, Examples & Interactive Practice

Last updated on October 3rd, 2026 at 04:36 pm

HLOOKUP in Excel is a lookup function used to search horizontally across the first row of a table and return a value from another row in the same column.

The “H” in HLOOKUP stands for Horizontal.

For example, suppose your Excel data is arranged like this:

If you want Excel to find Q3 and return the corresponding EBITDA, HLOOKUP can perform the lookup for you.

=HLOOKUP(“Q3”,B1:E4,3,FALSE)

Excel searches horizontally for Q3, moves down to the third row of the selected table, and returns 42.

Try Our HLOOKUP Formula Builder

Not sure how to construct an HLOOKUP formula? Use the interactive HLOOKUP Formula Builder below.

Choose what you want Excel to find, your table range, the row containing the result, and whether you need an exact or approximate match.

What Is HLOOKUP in Excel?

HLOOKUP is an Excel function designed for tables where the value you want to search for appears in the top row and the related information is arranged in rows underneath it.

Suppose you want to find the profit earned in March. Excel needs to:

1. Search horizontally across the first row for “Mar”.
2. Identify the column containing “Mar”.
3. Move down to the Profit row.
4. Return the value 65.

That is exactly what HLOOKUP does.

HLOOKUP = Horizontal Lookup

If your lookup values run vertically down a column instead, VLOOKUP may be more appropriate. In modern versions of Excel, XLOOKUP can handle both horizontal and vertical lookups.

HLOOKUP Formula and Syntax

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

1. Lookup Value

The lookup value is what you want Excel to find in the first row of the selected table.

For example:

“Q3”

Or a cell reference:

B8

2. Table Array

The table array is the range containing both your lookup values and the answer you want returned.

B1:E4

When copying the formula to other cells, you may want to lock the range using absolute references:

$B$1:$E$4

3. Row Index Number

The row index number tells Excel which row of the selected table contains the answer.

To return EBITDA, your row index number would be:

3

This number refers to the position within your selected table, not necessarily the worksheet’s actual row number.

4. Range Lookup

The final argument determines how Excel matches your lookup value.

FALSE

Use FALSE for an exact match.

TRUE

Use TRUE for an approximate match.

For most normal business lookups—such as finding a particular month, employee, product, quarter, or scenario—FALSE is usually what you want.

Important: If the fourth argument is omitted, HLOOKUP uses approximate matching. This can produce unexpected results when you intended to find an exact value.

How to Use HLOOKUP in Excel

Let’s build an HLOOKUP formula step by step.

We want Excel to return Q3 EBITDA.

Start the formula:

=HLOOKUP(

Our lookup value is:

“Q3”

Our complete table range is:

B1:E4

EBITDA is the third row of the selected table, so the row index number is:

3

Finally, we want an exact match:

FALSE

The completed formula becomes:

=HLOOKUP(“Q3”,B1:E4,3,FALSE)

The result is: ₹3,60,000

Find Q3 → Stay in the Q3 column → Move to Row 3 → Return ₹3,60,000

HLOOKUP Examples in Excel

Understanding the basic formula is only the beginning. Let’s look at situations where HLOOKUP becomes more useful.

Example 1: HLOOKUP with Exact Match

To return the price of a Monitor:

=HLOOKUP(“Monitor”,A1:E3,2,FALSE)

Excel returns ₹15,000. Because FALSE is used, Excel looks specifically for Monitor.

HLOOKUP Exact Match vs Approximate Match

Exact Match

Use FALSE when Excel must find the exact lookup value.

=HLOOKUP(“FY27E”,B1:F4,3,FALSE)

If FY27E does not exist in the first row, Excel normally returns #N/A.

Approximate Match

Use TRUE when you want Excel to find an appropriate value from an ordered range rather than an identical value.

If a student’s score is 82, you could use:

=HLOOKUP(82,B1:F2,2,TRUE)

Excel returns B. When using approximate HLOOKUP, the lookup values in the first row should be arranged in ascending order. Otherwise, the formula can return an incorrect result.

HLOOKUP from Another Sheet

HLOOKUP can also retrieve information stored on another worksheet. Suppose your data is stored on a worksheet called Financial Data and you want to find FY27E Revenue.

=HLOOKUP(“FY27E”,’Financial Data’!B1:F5,2,FALSE)

The sheet reference ‘Financial Data’! tells Excel where the lookup table is located.

=HLOOKUP(“FY27E”,’Financial Data’!$B$1:$F$5,2,FALSE)

Locking the table range is useful if you plan to copy the formula across multiple cells.

HLOOKUP with Wildcards

HLOOKUP can work with wildcard characters when performing an exact-match lookup.

• * — matches multiple characters
• ? — matches a single character

Suppose your first row contains Jan 2026 | Feb 2026 | Mar 2026 | Apr 2026.

=HLOOKUP(“Mar*”,A1:E3,2,FALSE)

The * allows Excel to match text beginning with “Mar”. This can be useful when the cell contains additional text that you do not want to type into the lookup formula.

HLOOKUP with MATCH

One limitation of a normal HLOOKUP formula is that you must manually tell Excel which row contains the answer.

=HLOOKUP(“FY27E”,A1:E5,4,FALSE)

If another row is inserted into your model, a hard-coded row number may no longer point to the information you intended. One solution is to combine HLOOKUP with MATCH.

=HLOOKUP(“FY27E”,A1:E4,MATCH(“EBITDA”,A1:A4,0),FALSE)

MATCH finds the position of EBITDA within the row labels. HLOOKUP then finds FY27E horizontally. Together, the functions identify both dimensions of the table. The result is 35.

HLOOKUP Example in Financial Modeling

If you are learning Excel for finance, it is better to understand lookup functions using realistic financial data.

Suppose an analyst wants to retrieve FY28E EBITDA.

=HLOOKUP(“FY28E”,B1:F4,3,FALSE)

The result is 45. This type of horizontally arranged time-series data is common in financial models.

HLOOKUP for Budget Analysis

=HLOOKUP(“Mar”,B1:E4,3,FALSE)

This retrieves March’s Technology budget: 240.

HLOOKUP for Scenario Analysis

=HLOOKUP(“Base Case”,B1:D4,3,FALSE)

This retrieves the EBITDA margin under the Base Case: 22%.

Common HLOOKUP Errors and How to Fix Them

HLOOKUP #N/A Error

A #N/A error usually means Excel could not find the requested lookup value. Check whether:

• The lookup value actually exists.
• The lookup value is in the first row of the selected table.
• Text contains unwanted spaces.
• Numbers are stored as text.
• You have selected the correct table.
• You intended to use FALSE for an exact match.

=HLOOKUP(“FY30E”,B1:F4,3,FALSE)

This returns #N/A if FY30E does not exist in the first row.

HLOOKUP #REF! Error

A #REF! error can occur when your row index number is larger than the number of rows available in the selected table.

=HLOOKUP(“Q3”,B1:F4,6,FALSE)

Excel cannot return a value from a sixth row that does not exist within a four-row selected table.

HLOOKUP Returns the Wrong Value

One common cause is accidentally using approximate matching.

=HLOOKUP(B8,B1:F5,3,TRUE)

If you require an exact match, use:

=HLOOKUP(B8,B1:F5,3,FALSE)

Always check the fourth argument when an HLOOKUP result appears incorrect.

HLOOKUP vs VLOOKUP

A simple rule to remember:

Horizontal lookup table → HLOOKUP

Vertical lookup table → VLOOKUP

HLOOKUP vs XLOOKUP

If you are using a modern version of Excel, you should also understand XLOOKUP. XLOOKUP can perform both vertical and horizontal searches.

=HLOOKUP(“Q3”,B1:E3,3,FALSE)

With XLOOKUP, the equivalent can be:

=XLOOKUP(“Q3”,B1:E1,B3:E3)

Should You Still Learn HLOOKUP?

Yes, but you should also learn XLOOKUP.

HLOOKUP remains useful because you may encounter it in existing Excel workbooks, financial models, templates, and older versions of Excel.

Understanding HLOOKUP also helps you understand the basic logic behind lookup functions: Find something → identify its position → return related information.

If you are building a new workbook using a modern version of Excel, XLOOKUP will often provide a more flexible solution. The important skill is not memorising one Excel function; it is understanding which lookup method is appropriate for the structure of your data.

Download the HLOOKUP Practice Workbook

Reading formulas is useful. Building them yourself is better.

Use our HLOOKUP Excel Practice Workbook to practise:

• Basic HLOOKUP
• Exact-match HLOOKUP
• Approximate-match HLOOKUP
• Cross-sheet HLOOKUP
• HLOOKUP with wildcards
• HLOOKUP + MATCH
• Financial modeling lookup exercises

[DOWNLOAD HLOOKUP EXCEL PRACTICE FILE]

Try solving the questions before checking the solutions.

Test Your HLOOKUP Knowledge

Question 1

What does the “H” in HLOOKUP represent?

A. Header

B. Horizontal

C. Higher

D. Hybrid

Answer: B — Horizontal

Question 2

Which argument should normally be used when you require an exact match?

A. TRUE

B. FALSE

C. MATCH

D. EXACT

Answer: B — FALSE

Question 3

What does the row index number tell HLOOKUP?

A. Which worksheet to use

B. Which column to search

C. Which row of the selected table should return the answer

D. Which cell contains the formula

Answer: C

Question 4

Which function can perform both horizontal and vertical lookups in modern Excel?

A. SUMIF

B. COUNTIF

C. XLOOKUP

D. ROUND

Answer: C — XLOOKUP

Question 5

You have years across the first row and financial metrics underneath them. Which traditional Excel lookup function is designed for this structure?

A. VLOOKUP

B. HLOOKUP

C. SUM

D. IF

Answer: B — HLOOKUP

Frequently Asked Questions About HLOOKUP

What is HLOOKUP in Excel?

HLOOKUP is an Excel lookup function that searches for a value horizontally across the first row of a table and returns a corresponding value from another row in the same column.

What is the HLOOKUP formula?

The syntax is =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]). For example: =HLOOKUP(“Q3”,B1:E4,3,FALSE)

What does HLOOKUP stand for?

HLOOKUP stands for Horizontal Lookup. It is designed for data where lookup values are arranged horizontally across the first row of a table.

What is the difference between HLOOKUP and VLOOKUP?

HLOOKUP searches across the first row of a table, while VLOOKUP searches down the first column. The correct function depends primarily on how your data is arranged.

What is FALSE in HLOOKUP?

FALSE tells Excel to look for an exact match to the lookup value.

What does TRUE mean in HLOOKUP?

TRUE tells HLOOKUP to perform an approximate match. Approximate matching is useful for situations involving ordered thresholds or ranges, such as grades, commissions, or tax bands.

Why is my HLOOKUP returning #N/A?

Common causes include a missing lookup value, selecting the wrong table, searching for a value that is not in the first row, differences between numbers and text, or unwanted spaces.

Can HLOOKUP work between different sheets?

Yes. The table array can reference another worksheet, for example: =HLOOKUP(“FY27E”,’Financial Data’!$B$1:$F$5,2,FALSE)

Can HLOOKUP search from another workbook?

Yes. HLOOKUP can reference ranges contained in another Excel workbook. The external workbook and worksheet become part of the table reference.

Is HLOOKUP better than VLOOKUP?

Neither function is universally better. HLOOKUP is designed for horizontally arranged lookup values, while VLOOKUP is designed for vertically arranged lookup values.

Is XLOOKUP better than HLOOKUP?

For many modern Excel applications, XLOOKUP is more flexible. It can search horizontally or vertically, uses exact matching by default, and does not require a hard-coded row index number. HLOOKUP remains useful for older Excel versions and existing spreadsheets that already use it.

Is HLOOKUP still used in Excel?

Yes. HLOOKUP remains available and is still found in existing spreadsheets and financial models. Users of modern Excel should also understand XLOOKUP and other more flexible lookup methods.

How do I remember HLOOKUP?

Remember: H = Horizontal. If the values you are searching through run across the top of your table from left to right, think of HLOOKUP.

Learn Excel for Real-World Finance

Excel becomes much more powerful when functions such as HLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS, and other formulas are combined inside practical financial models.

At MentorMeCareers, our Financial Modeling training focuses on applying Excel to financial statements, forecasting, valuation, budgeting, and other practical finance applications rather than learning formulas in isolation.

Explore the advance excel course