Looks for the specified value in the specified list of values and returns the corresponding result.
Syntax
 Copy Code
|
|---|
LOOKUP( Any lookup, ReferenceOrArray searched, [ReferenceOrArray result] ) → Any |
Parameters
- 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.
See Also
Function Reference
HLOOKUP Function
INDEX Function
MATCH Function
OFFSET Function
VLOOKUP Function