Returns a value from a range or array that matches a specified lookup value.
Ta funkcja działa w Arkuszach Google tak samo jak w Excelu — ta sama składnia i argumenty.
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"})Wynik: 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.