EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Lookup & Reference Functions in Excel HLOOKUP Examples
Secondary Sidebar
Excel Functions
  • Lookup and Reference Functions in Excel
    • VLOOKUP Function in EXCEL
    • VLOOKUP True
    • VLOOKUP Error
    • How to Match Data in Excel
    • Excel Match Function
    • Excel Lookup Function
    • ROWS Function in Excel
    • Excel INDEX Function
    • VLOOKUP Table Array
    • Excel OFFSET Formula
    • VLOOKUP For Text
    • IF VLOOKUP Formula in Excel
    • Mixed Reference in Excel
    • CHOOSE Formula in Excel
    • Excel COLUMN to Number
    • Excel Alternatives to VLOOKUP
    • HLOOKUP Examples
    • Excel VLOOKUP From Another Sheet
    • VLOOKUP with Sum
    • Fixing VLOOKUP Errors
    • Excel ROW Function
    • HYPERLINK in Excel
    • Address Excel Function
    • Excel COLUMNS Function
    • Excel REPLACE Function
    • OFFSET Excel Function
    • Excel GETPIVOTDATA Function
    • MATCH Function in Excel
    • VLOOKUP Function in Excel
    • HLOOKUP Function in Excel
    • LOOKUP in Excel
    • CHOOSE Function in Excel
    • TRANSPOSE in Excel
    • COLUMN Function in Excel
    • INDIRECT Function in Excel
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL COURSE
  • Online EXCEL ADVANCED Training

HLOOKUP Examples

By Madhuri ThakurMadhuri Thakur

HLOOKUP Examples in Excel

Excel HLOOKUP Examples (Table of Contents)

  • HLOOKUP Examples
  • HLOOKUP Example in Excel – Illustration #1
  • HLOOKUP Example in Excel – Illustration #2

Examples of HLOOKUP

Hlookup is used for mapping and looking up the values that are horizontally filled. Similar to Vlookup, Hlookup is also having the same syntax. Below are the different Hlookup examples in Excel.

HLOOKUP Example in Excel – Illustration #1

Here we have sample data of some customers who bought some products on different dates of a month, and the data is horizontal.

You can download this HLOOKUP Examples Excel Template here – HLOOKUP Examples Excel Template

Illustration #1

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Now we will test Hlookup for the data shown in the above table, and the location of the output cell will be B7 which is marked below with the heading Quantity.

Before we apply Hlookup, first, let’s see the syntax of Hlookup as shown below.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,725 ratings)

Hlookup Formula

  • Lookup_value: It is the fixed reference lookup cell for which we need to find the value.
  • Table_array: It is that table from which we need to find the value.
  • Row_index_num: Exact sequence of a row for looking up the value.
  • [Range_lookup]: Here, we will fix an exact or approximate match as per data type.

Now let’s use Hlookup in excel. For this, go to that cell, where we need to find the value. Here we are choosing cell B7.

Hlookup Example 1-2

Type “=” (Equal) sign. By this, all the inbuilt functions in excel will get enabled. Now select Hlookup.

Hlookup Example 1-3

Lookup_Value = Select the reference cell A7.

Hlookup Example 1-4

Table_array = Select table array B1:K3, which covers the complete table.

Hlookup Example 1-5

Row_index_num = Select row 2, by typing 2.

Hlookup Example 1-6

[Range_lookup] = Select FALSE or “0” for an exact match as our data is quite simple to understand.

Hlookup Example 1-7
As we can see in the above screenshot, how our applied Hlookup final formula will look like. The red color table is our table array, the Blue color cell is our lookup value, and 2 is row 2 from the selected table array.

Once we press Enter, we will get the applied formula as shown below.

N/A Error

#N/A in the above screenshot can be seen because no reference value is filled in cell A7. But that doesn’t mean that the applied formula is incorrect. The correctness of the formula can be measured once we enter some value from the table array to cell A7. Now fill cell A7 with any of the table_array value of the same header name Customer Name. Let’s enter Customer 4 here and cell the result.

Result of Illustration #1

As we can see in the above screenshot, after entering Customer 4 in A7, applied Hlookup mapped the value from the selected table array of the reference cell to give the value like 23 in B7. This is how Hlookup works.

HLOOKUP Example in Excel – Illustration #2

There is one more method of applying Hlookup. For this, put the cursor to a cell where we need to apply Hlookup and then go to the Formula menu tab and click on Insert Function, as shown in the below screenshot.

Illustration #2

Once we click on it, we will get the Insert Function box which has all the list of inbuilt functions of excel as shown below. From the tab or select a category, choose All as circled below to get the list of all functions, and from Select, a function box, select Hlookup and click on OK. Or else type Hlookup or Keyword related to this in Search for a function box.

Hlookup Example 2-2

After that, we will function the argument box when we need to select the same range and criteria as we did in example 1 and click on Ok.

Hlookup Example 2-3

As we can see, the Formula result is showing blank. But it doesn’t mean that our formula is incorrect. We will check the correctness of the formula once we click on Ok and put the lookup value in A7. After clicking on Ok, we will get the below-applied formula.

Hlookup Example 2-4

Now to test if the formula is applied or not, enter any customer name in cell A7. For testing, let’s enter Customer 5 in cell A7. Once we do this, the value of Customer 5 from the table array will get looked up with the same header Customer Name as 55.

Result of Illustration #2

As we got the looked-up value like 55 in cell B7, which means that our applied formula is correct.

Things to Remember

  • If the Lookup Value is not the exact value in the data table, we will get a # N/A error.
  • The structure of the data table is very important. If the data table is horizontal, HLOOKUP should be applied, and VLOOKUP should be applied if the table is vertical.
  • Like VLOOKUP, HLOOKUP also limits the collection of data from top to bottom and not from bottom to top.

Recommended Articles

This has been a guide to HLOOKUP Examples in excel. Here we discuss various HLOOKUP Examples in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. HLOOKUP in Excel
  2. VBA VLOOKUP Function
  3. IFERROR with VLOOKUP in Excel
  4. LOOKUP in Excel
Popular Course in this category
Excel Training (23 Courses, 9+ Projects)
  23 Online Courses |  9 Hands-on Projects |  110+ Hours |  Verifiable Certificate of Completion
4.9
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
13 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download HLOOKUP Examples Excel Template

EDUCBA

Download HLOOKUP Examples Excel Template

EDUCBA

डाउनलोड HLOOKUP Examples Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more