HLOOKUP
Searches for a value in the first row of a table array and returns a value in the same column from a specified row.
| Category | Lookup |
| Syntax | HLOOKUP(lookup_value, table_array, row_index, [range_lookup]) |
Parameters
| Parameter | Required | Description |
|---|---|---|
lookup_value | Required | The value to search for in the first row of the table array. |
table_array | Required | The range of cells containing the data. |
row_index | Required | The row number in the table_array from which to return the matching value. |
range_lookup | Optional | [Optional] TRUE (default) for approximate match (first row must be sorted). FALSE for exact match. |
Example
HLOOKUP(value, range, col)
Auto-generated from the EngCanvas function registry.