HLOOKUP

Searches for a key in the first row of a range and returns the value from a specified row in the same column. Used for horizontal lookups.

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:

HLOOKUP("Female", A1:B2, 2, FALSE) returns "100,500.00"