HLOOKUP

Search for a value in a horizonally-arranged data set.

Syntax:

HLOOKUP(key, array, row_index:number)

Looks up the given key value in the first row of the array and returns the corresponding value in that array or range of cells from the row specified by row_index.

array must be a horizontally-arranged set of data, sorted in ascending order.

row_index=1 would yield a return value from the first row in the array. row_index=2 would yield a return value from the second row, and so on.

If key is not found, the closest lower value is returned.