HLOOKUP
Searches for a value in the top row of a table and returns a value in the same column from a row you specify
Syntax
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Parameters
- lookup_value: Required. The value to search for in the first row of the table
- table_array: Required. A table of information in which data is looked up
- row_index_num: Required. The row number in table_array from which the matching value will be returned
- range_lookup: Optional. TRUE for approximate match (default), FALSE for exact match
Example
=HLOOKUP("Bolts", A1:D4, 3, FALSE)