LOOKUP
Description
This function looks for a value in a 1-dimensional list and returns the value from
the same position in a second list.
Syntax
LOOKUP(
lookup_value
,
lookup_vector
, [
result_vector
])
- lookup_value: The value to find.
- lookup_vector: The list to search in.
- result_vector: The list to return a value from. If not specified, the function uses thelookup_vector.
Example
The examples are based on this workbook:
A | B | C | |
|---|---|---|---|
1 | # Sold - Upper Limit | Level | |
2 | 199 | Too Low | |
3 | 299 | Bronze | |
4 | 399 | Silver | |
5 | 1000 | Gold | |
6 | Geoff | 388 |
The result of
=LOOKUP(B6,B2:B5,C2:C5)
is
Bronze
.
Notes
- You must sort thelookup_vectorin ascending order.
- If the LOOKUP function can't find the lookup_value, it returns the largest value in lookup_vector that is less than or equal to lookup_value.
- Use VLOOKUP or HLOOKUP for lookup operations on arrays.
Related Functions
ARRAYAREA
GROUPBY
MATCHEXACT
MVLOOKUP