Articles with the tag:
Articles with the tag:
Try in the cloud
Try in the cloud

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).


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.


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.


The figure below displays the result returned by the LOOKUP function.

lookup function gif

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action