Functions
LOOKUP
Approximate lookup in sorted range
Try it
When to use it
When should I use LOOKUP instead of VLOOKUP?
Use LOOKUP for a simple search across a single sorted vector returning a parallel result vector; use VLOOKUP to pull a column from a table by a key.
Does LOOKUP need its search data sorted?
Yes. LOOKUP assumes the search vector is sorted in ascending order and returns the largest value at or below the lookup value.
Use cases
Map a score to a letter grade band
Find a tier price from sorted quantity breaks
Used in
operations · sales · retail
Syntax
LOOKUP(search_key, search_range, [result_range])