LOOKUP Function
The LOOKUP function is one of the lookup and reference functions. It is used to return a value from a selected range (row or column containing the data in ascending order).
Syntax
LOOKUP(lookup_value, lookup_vector, [result_vector])
The LOOKUP function has the following arguments:
Argument |
Description |
lookup_value |
A value to search for. |
lookup_vector |
A single row or column containing data sorted in ascending order. |
result_vector |
A single row or column of data that is the same size as the lookup_vector. |
Notes
The function searches for the lookup_value in the lookup_vector and returns the value from the same position in the result_vector.
If the lookup_value is smaller than all of the values in the lookup_vector, the function will return the #N/A error. If there is not a value that strictly matches the lookup_value, the function chooses the largest value in the lookup_vector that is less than or equal to the value.
How to apply the LOOKUP function.
Examples
The figure below displays the result returned by the LOOKUP function.
![lookup function gif](https://helpcenter.onlyoffice.com/OfficeWeb/apps/spreadsheeteditor/main/resources/help/en/images/lookup_function.gif)
Return to previous page