Microsoft Excel Hlookup Tutorial

In other words it allows you to find look up a value from one column of data and returns its respective or corresponding value from another column.

Microsoft excel hlookup tutorial. Uses of hlookup function. Lets take an example and understand how and where we can use hlookup function in microsoft excel 2010 and 2013. These functions let you search through the excel table containing data based on users requirement and extract the appropriate result from the table. We used this function to pick the values from one data to another but the condition is we should have the common values in both datas so we can easily pick the value.

It can be used as a worksheet function ws in excel. It looks up a value you designate in the first row of a worksheet area called a range and returns a value from the column it finds the lookup value in. Hlookup is one of those functions and this tutorial will show you how to use the hlookup function to lookup data within a table based on values you select. Many people are familiar with the vlookup vertical lookup function but hlookup is often unfairly overlooked.

What is the microsoft excel hlookup function. Use hlookup when your comparison values are located in a row across the top of a table of data and you want to look down a specified number of rows. This tutorial is for excel 2019 microsoft 365 for windows. In the rest of this article youll see just how powerful hlookup can be.

Searches for a value in the top row of a table or an array of values and then returns a value in the same column from a row you specify in the table or array. Vlookup v stands for vertical is an in built function in excel which allows establishing a relationship between different columns of excel. Description the hlookup function searches for a value in the top row of a table or an array of values and then returns a value in the same column from a row you specify in the table or array. The microsoft excel hlookup function performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same column based on the indexnumber.

In this vlookup guide we will learn. We have 2 data sets. Click image to enlarge vlookup and hlookup are two powerful functions in microsoft excel that allow you to use a specific section of your excel spreadsheet to search for the correct data. Hlookup is a very useful function for creating horizontal lookups but as most of the tables that we deal with are vertical hence this function is not very popular.

Hlookup function in excel is a sibling of the vlookup functionthe h in the hlookup stands for horizontal and hence it is often called horizontal lookup.