LOOKUP
Looks up values in a vector or array.
Lookup & ReferenceLookup & Matching Essentials
What it does
Backward compatibility lookup function. Always approximate match.
Syntax
LOOKUP(lookup_value, lookup_vector, [result_vector])
Arguments
lookup_value(value) — Value to find.lookup_vector(range) — Range to search.result_vector(range) — Range to return from.
Examples
Vector Lookup
Find score grade.
FORMULA
=LOOKUP(85, A2:A4, B2:B4)
RESULT
B
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Score | Grade |
| 2 | 0 | F |
| 3 | 70 | C |
| 4 | 80 | B |