LOOKUP
Lookup & referenceExcel 2007Legacy approximate-match lookup over a sorted vector.
Syntax
LOOKUP(lookup_value, lookup_vector, [result_vector])
How it works
Requires lookup_vector sorted ascending. Modern equivalent: XLOOKUP with match_mode -1.
Examples
=LOOKUP(2, 1/(A2:A100<>""), A2:A100)
→ last non-blank value — classic trick
Related functions
More Lookup & reference functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.