HLOOKUP
Description
Finds a value in the top row of the specified data array, and returns the value for the corresponding cell in the same column in a different row.
Syntax
HLOOKUP(
lookup_value
,
table_array
,
row_index_num
, [
range_lookup
])
- lookup_value: The value to find in the first row.
- table_array: The array or table to search.
- row_index_num: The row to return the corresponding value from.
- range_lookup: Specifies whether to require an exact match. FALSE = return an error if an exact match is not found; TRUE or Empty = if the function doesn't find an exact match, use the closest match below the lookup_value as a match.
Related Functions
ARRAYAREA
GROUPBY
MATCHEXACT
MHLOOKUP