LOOKUP Function Explained
The LOOKUP function in Microsoft Excel is used to search for a value in a row or column and return a corresponding value from the same position in a different row or column. It can be used to search for a value in a single row or column, or in multiple rows and columns. It can also be used to search for an approximate match or an exact match.
LOOKUP Function Syntax
LOOKUP(lookup_value, lookup_vector, [result_vector])
- lookup_value: The value to search for in the first vector.
- lookup_vector: The vector to search in. It must be sorted in ascending order.
- result_vector: (Optional) The vector in which to return the value. If omitted, lookup_vector is used.