Parameter List
Syntax
HLOOKUP(search_key, range, index,
[is_sorted]
)search_key
The value to search for in the first column. For example: "Super", 123, or A1.
range
The two-dimensional range or JSON data to consider for the search. The first row must include the search_key. For example: A1:C5.
index
The row index that contains the value you want. For example: 3. The search_key row is row 1.
[optional] is_sorted
A boolean value specifying whether the first row of the range is sorted: Choose either:
TRUE(default) to get the closest matchFALSEto get the first exact match