Excel HLOOKUP() Function

Excel HLOOKUP() Function

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. This function is similar to VLOOKUP. In a VLOOKUP, we look at columns, whereas in HLOOKUP, we look at rows.

Syntax

HLOOKUP(LookupValue, Table_Array, Row_Index_Num, [Range_Lookup])

Parameter

LookupValue(required)- This parameter represents the value which needs to be looked for in a particular table.

Table_Array (required)- This parameter refers to the table in which we need to check for this value to be present and from which we want to retrieve data. By pressing the F2 key when you have selected your table, you fix the range. So when you copy the formula from one cell to another, the range does not update automatically.

Index_Num(required)- If the value is present in the table, then which column consists of the value we want the function to return

Range_Lookup(optional)- This parameter takes a Boolean value - TRUE for approximate match and FALSE (which is the default value) for an exact match of the value we are searching for in a table.

Category

Lookup & Reference

Return

The HLOOKUP function looks for a value in the first row of a table and returns a value from the same column in that table.

Example 1

Objective: Below in the first table, we have a sales commission for different cars. Use HLOOKUP() to get the amount each employee will get based on the car they sold.

Example 2

Objective: How much % target achieved by 'Value 4’ in Eoo4