WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » VLOOKUP vs HLOOKUP

VLOOKUP vs HLOOKUP

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Difference Between VLOOKUP and HLOOKUP

Vlookup and Hlookup both are a referencing function in excel which are used to reference a data to match with a table array or a group of data and display the output, the difference between these referencing functions is that Vlookup uses to reference with columns while Hlookup uses to reference with rows.

VLOOKUP-vs-HLOOKUP

VLOOKUP and HLOOKUP are the two important functions we use in Microsoft Excel. These functions allow us to search a range of data that are gathered from the users and provide us with the right information that we’re looking for.

The VLOOKUP function is used when we have a set of data vertically.

Example of VLOOKUP and HLOOKUP

Let’s take an example to illustrate the difference between VLOOKUP and HLOOKUP.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example Given Data

Let’s say that we have a table here where we’re given the employee ID, employee name, and performance grade.

Now, let’s say that you, as a user, have provided only employee ID. By using the VLOOKUP function, Excel will be able to provide you with the employee name and the performance grade given by HR.

Here’s how it will look like –

Function Data

Now, if we use the same data for finding out the HLOOKUP, how will it work?

The only basic difference between VLOOKUP and HLOOKUP is that VLOOKUP works when the table is vertically set up, and HLOOKUP works when the setup of the table is horizontal.

Meaning, to find out the VLOOKUP function, we will see the table column-wise, whereas to find out the HLOOKUP function, we will look at a table that is set up row-wise.

So, if we need to find out the HLOOKUP, we need to look at a table like this –

Employee Information

By using HLOOKUP, we will get exactly the same result, but the table is arranged differently.

Let’s look at the formula of both. And if you notice, you would see that there’s only one difference in both the formulas, and that is the portion of row or column.

The formula of VLOOKUP is

vlookup formula

The formula of HLOOKUP is

hlookup formula

VLOOKUP vs. HLOOKUP Infographics

VLookUp-vs-HLookUp

Key Differences

The key differences are as follows –

  • The basic difference is while applying the VLOOKUP function. We need a vertical table. And for the HLOOKUP function to work, we need to look at a horizontal table.
  • VLOOKUP is a more popular function in Microsoft Excel, and many use it all the time. At the same time, HLOOKUP is not used frequently and only used in some cases.
  • Both are used for the same output. But their approach is different.
  • The formula of VLOOKUP is =VLOOKUP (lookup_value, table_array, col_index_number, [range_lookup]) and the formula of HLOOKUP is =HLOOKUP (lookup_value, table_array, row_index_number, [range_lookup]). If you notice closely, you will see that there’s only one difference between these two formulas, and that is of row and column.
  • VLOOKUP helps you find out the data in the leftmost column. On the other hand, HLOOKUP is used to find out the data from a range in the bottom-most rows.

Comparative Table

Basic for Comparison VLOOKUP HLOOKUP
Meaning VLOOKUP function is used to find out particular data from a vertical spreadsheet. HLOOKUP function is used to find out particular data from a horizontal spreadsheet.
Usage VLOOKUP is one of the most used functions in excel. HLOOKUP is used but not as frequently as VLOOKUP is used.
Output VLOOKUP provides the same output HLOOKUP provides. In terms of output, there’s no difference between VLOOKUP and HLOOKUP.
Type of table To find out the VLOOKUP function, we need to look at a vertical table. To find out the HLOOKUP function, we need to look at a horizontal table.
Searched data When the user is using VLOOKUP, she is searching for the data in the leftmost column. When the user is using HLOOKUP, she is searching for the data in the bottom-most row.
Syntax =VLOOKUP (lookup_value, table_array, col_index_number, [range_lookup]) =HLOOKUP (lookup_value, table_array, row_index_number, [range_lookup])

Final Thoughts

The difference between VLOOKUP and HLOOKUP is negligible if we look closely. At the same time, using VLOOKUP is quite easy, and users find it most suitable for finding out particular information from a range of data.

HLOOKUP isn’t used very frequently, but it is used when VLOOKUP can’t be used.

Recommended Articles

This has been a guide to VLOOKUP vs. HLOOKUP. Here we discuss the top difference between VLOOKUP and HLOOKUP along with infographics and comparison table. You may also have a look at the following articles –

  • VLOOKUP Examples
  • Examples of HLOOKUP
  • VLOOKUP Error
  • Absolute in Excel
2 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

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

Login

Forgot Password?

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More