Returns a value from a range or array that matches a specified lookup value.
Syntax
LOOKUP(lookup_value, lookup_vector, [result_vector])Argumente
lookup_valueerforderlich
The value that you want to search for in the lookup_vector.
lookup_vectorerforderlich
The range containing only one row or one column to search.
result_vectoroptional
The range containing the value to return; must be the same size as lookup_vector.
The LOOKUP function searches for a value in a one-row or one-column range and returns a value from the same position in a second one-row or one-column range. It is often used for simple lookups where data is sorted in ascending order.
=LOOKUP(102, {100, 101, 102}, {"A", "B", "C"})→CSearches for 102 in the first array and returns the corresponding value from the second array.
Prepare your data
Ensure your lookup_vector is sorted in ascending order for accurate results.
Enter the formula
Type =LOOKUP followed by the lookup value, the search range, and the result range.
Yes, for the vector form, the lookup_vector must be sorted in ascending order to return correct results.