Returns a value from a range or array that matches a specified lookup value.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
LOOKUP(lookup_value, lookup_vector, [result_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"})Ergebnis: C
Searches for 102 in the first array and returns the corresponding value from the second array.
Yes, for the vector form, the lookup_vector must be sorted in ascending order to return correct results.