Excel Hlookup Function Tutorial

Hlookup lookupvalue tablearray rowindexnumber rangelookup optional much like vlookup hlookup takes a lookupvalue argument which defines what the function will be searching for.

Excel hlookup function tutorial. The hlookup function is available in excel 2016 excel 2013 excel 2010 excel 2007 excel 2003 excel xp excel 2000 excel 2011 for mac. This tutorial is designed for beginners but some basic excel skills are necessary to create the worksheets and follow the step by step instructions given in the tutorial. The syntax of the hlookup function is as below. Hlookup is a lookup and reference function.

The vector type searches only one row or column while an array searches multiple rows and columns. Hlookup function in excel comes with the following arguments. The hlookup function in excel is used to search a value in the topmost row of a table and then return a corresponding value in the same column for the specified row. 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 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. In a vlookup we look at columns whereas in hlookup we look at rows. Hlookup lookupvalue tablearray rowindexnum rangelookup as you can see in the screenshot above we need to give the lookupvalue first. There are two ways to use a lookup formula depending on your needs.

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. Most of the tables in excel create a vertical so this feature is rarely used. The hlookup function is a build in function in microsoft excel and it is categorized as a lookup and reference function. 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.

This function is similar to vlookup. As a vector and an array. This function retrieves data from the table horizontally. The syntax of the hlookup function is as follows.

The hlookup worksheet function is used in applications when you have to look up prices name information scientific data anything that is contained in a table. The lookup function in excel is used to look up information in a row or column. You run the hlookup worksheet function by typing its name in a formula then followed by the information it is suppose to use.