LOOKUP
Looks up values in a vector or array
Syntax
LOOKUP(lookup_value, lookup_vector, [result_vector])
Parameters
- lookup_value: Required. A value that LOOKUP searches for in the first vector
- lookup_vector: Required. A range that contains only one row or one column, sorted in ascending order
- result_vector: Optional. A range that contains only one row or column, same size as lookup_vector
Example
=LOOKUP(7.66, A1:A5, B1:B5)