Excel Tutorial Hlookup

Vlookup v stands for vertical is an in built function in excel which allows establishing a relationship between different columns of excel.

Excel tutorial hlookup. You can 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. In this vlookup guide we will learn. For example look at the below data. Hlookup supports approximate and exact matching and wildcards for finding partial matches.

Most of the tables in excel create a vertical so this feature is rarely used. This is the master data you have. This function retrieves data from the table horizontally. 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.

The h in hlookup stands for horizontal where lookup values appear in the first row of the table moving horizontally to the right. Assume you are working in an hr department and you are dealing with employees information like salary doj etc. Here are some examples of the hlookup function in excel. Despite it i think its worth it to know hlookup.

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. Hlookup is an excel function to lookup and retrieve data from a specific row in table. 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. Hlookup function has the following form.

Its just like a vlookup except that it performs lookups horizontally rather than verticallyread on to find out how to use this handy formula. Hlookup examples in excel.