fx =OFFSET(A1,5,2)ABCSKU-4821Widget A$24.99SKU-7293Gadget B$89.50SKU-1056Tool C$12.75
🔍 Lookup

OFFSET Formula for Lookup

Reference a cell offset from a starting point. Copy-paste ready for Excel, Google Sheets, and Airtable.

=OFFSET(A1,5,2)
When you need this: When you need a rolling 12-month average: start at A1 (first month) and grab the last 12 cells dynamically.

How it works

  1. 1OFFSET starts at a reference cell (A1).
  2. 2Moves down rows (5) and right columns (2).
  3. 3Can return a range if you specify height/width.
  4. 4Perfect for dynamic calculations that adapt to data.

Variations

OFFSET for rolling average
=AVERAGE(OFFSET(A1,-11,0,12,1))
OFFSET returning a range
=SUM(OFFSET(A1,0,0,5,2))

Related Formulas

VLOOKUP — Look up a value in a table by matching the first columnLookupINDEX/MATCH — Flexible lookup - more powerful than VLOOKUPLookupXLOOKUP — Modern replacement for VLOOKUP (Excel 365)LookupFILTER — Return rows matching criteria (dynamic filter)Lookup

Need a formula that's not here?

Generate custom formula →