HLOOKUP Function
The HLOOKUP function is one of the lookup and reference functions. It is used to perform the horizontal search for a value in the top row of a table or an array and return the value in the same column based on a specified row index number.
Syntax
HLOOKUP (lookup_value, table_array, row_index_num, [range_lookup])
The HLOOKUP function has the following arguments:
Argument |
Description |
lookup_value |
A value to search for. |
table_array |
Two or more rows containing data sorted in ascending order. |
row_index_num |
A row number in the same column of the table_array, a numeric value greater than or equal to 1 but less than the number of rows in the table_array. |
range_lookup |
An optional argument. It is a logical value: TRUE or FALSE. Enter FALSE to find an exact match. Enter TRUE to find an approximate match, in this case if there is not a value that strictly matches the lookup_value, then the function will choose the next largest value less than the lookup_value. If this argument is absent, the function will find an approximate match. |
Notes
If the range_lookup is set to FALSE, but no exact match is found, then the function will return the #N/A error.
How to apply the HLOOKUP function.
Examples
The figure below displays the result returned by the HLOOKUP function.
Return to previous page