Searches for a value in the top row of the specified table or array of values, and returns a value in the same column from another specified row in the table or array.
Syntax
 Copy Code
|
|---|
HLOOKUP( Any lookup, ReferenceOrArray dataSource, Integer row, [Logical rangeLookup = TRUE] ) → Any |
Parameters
- lookup
- Required. The value to search for in the first row of the table. The lookup value can be a value or a reference.
- dataSource
- Required. The table to be looked up. The source can be a reference to a range of cells or an array.
- row
- Required. The row number in dataSource from which the matching value will be returned.
- rangeLookup
- Optional. A logical value indicating whether HLOOKUP should find an exact or an approximate match.
Remarks
If HLOOKUP cannot find lookup, and rangeLookup is TRUE (or omitted), it uses the largest value that is less than lookup. If rangeLookup is FALSE, HLOOKUP will find an exact match. If one is not found, the error value #N/A is returned.
See Also
Function Reference
INDEX Function
MATCH Function
OFFSET Function
VLOOKUP Function