EXCEL HLOOKUP FUNCTION
Excel HLOOKUP Function Introduction
This Function looks for a value in a table’s first row. It obtains a value from the provided row in the match column. When the lookup values are in the first row of a table, use HLOOKUP. This function is similar to VLOOKUP, except that whereas VLOOKUP searches vertically, HLOOKUP searches horizontally. This function will search a table for a value by matching on the first row.
Description of Excel HLOOKUP Function
Syntax:
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Parameter list:
- lookup_value – the value to be searched for.
- table_array – the table from which data will be retrieved.
- row_index_num – the row number from which data is to be retrieved.
- range_lookup – [optional] a boolean to indicate whether the match is precise or approximate.
- TRUE = approximate match, FALSE = precise match is the default.
Step By Step Guide of HLOOKUP Function
Example :
- In this example, we’re looking at how much Arnold and Jomy scored in Physics and Math. HLOOKUP requires four parameters, which we must give.
- We’re looking for the name Arnold or Jomy in the first argument, so we’ll put it in double quotes (text should be provided in double quotes).
- The second argument specifies where we will search; because the whole name and mark details are in the range B1:E4, we will use that as the second parameter.
- The third parameter is the row number, which is 2 for Physics and 3 for Maths. (Beginning with the name row)
- To get an exact match, we enter 0 or False for the fourth argument.
Key Points
- Range lookup determines whether the value must match perfectly or not. The default value is TRUE, which means that non-exact matches are permitted.
- To demand an exact match, set range lookup to FALSE, and items in the first row of the table do not need to be sorted.
- If range lookup is set to TRUE (the default), a non-exact match will force the HLOOKUP function to match or match the closest value in the table that is still less than value.
- If range lookup is set to TRUE (the default), ensure that the lookup values in the first row of the table are ordered ascending. Otherwise, HLOOKUP may return an unexpected or erroneous value.
- If there are many values in the table, this method will only select the first one.
Excel HLOOKUP Function Template/Exercise
- Download HLOOKUP Function Template
Related Functions
LOOKUP Function
LOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
