HLOOKUP

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

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