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).
The LOOKUP function syntax is:
LOOKUP(lookup-value, lookup-vector, result-vector)
lookup-value is a value to search for.
lookup-vector is a single row or column containing data sorted in ascending order.
lookup-result is a single row or column of data that is the same size as the lookup-vector.
The function searches for the lookup-value in the lookup-vector and returns the value from the same position in the lookup-result.
Note: 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.
To apply the LOOKUP function,
- select the cell where you wish to display the result,
- click the Insert Function icon situated at the top toolbar,
or right-click within a selected cell and select the Insert Function option from the menu,
or click the icon situated at the formula bar,
- select the Lookup and Reference function group from the list,
- click the LOOKUP function,
- enter the required arguments separating them by comma,
- press the Enter button.
The result will be displayed in the selected cell.
Return to previous page