Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
LOOKUP
LOOKUP searches a sorted one-row or one-column range for a value and returns the corresponding value from a second range of the same size. It is commonly used for simple lookups in sorted data where VLOOKUP or HLOOKUP would be more verbose. LOOKUP always uses approximate match, so the lookup range must be sorted in ascending order.
Excel
=LOOKUP(B2,A2:A5,B2:B5)Google Sheets
=LOOKUP(B2,A2:A5,B2:B5)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1B2 is the lookup value — LOOKUP searches for this value in the first range.
- 2A2:A5 is the sorted lookup vector — the column or row where the search happens (must be ascending).
- 3B2:B5 is the result vector — the value at the matching position in this range is returned.