LOOKUP

lookup: Required. The value to look for in the searched list.
searched: Required. A reference or array that contains only one row or column.
result: Optional. A reference or array that contains only one row or column of the same size as searched.

Remarks

The values in the searched list must be sorted in ascending order. The lookup value and the values in the searched list must be numeric or text.

This function searches for the lookup value in the searched list. The match is the largest value in searched that is less than or equal to lookup. From a sequence of identical values, the last value is selected. If lookup is smaller than the smallest of all values in searched, the function returns #N/A. When a match is found in searched, the function returns the corresponding value from the result list, or, if result is omitted, the function returns the found value.

The searched list shall be sorted in ascending order, so that values of numeric types precede text values if both types are included (for example, -2, 0, 1, "A", "B", "D"). The searched list must be a vector. That is, if searched is a cell reference, the referenced range must have one row or one column, if searched is an array, it must be one-dimensional. If searched is not a vector, the function returns #N/A.

Parameters

Remarks

See Also