What OFFSET does
OFFSET returns a reference that starts from one place and moves by the number of rows and columns you specify. Because it returns a reference, not just a value, it can drive other formulas dynamically.
Practical examples
Return a cell one row down and two columns over
=OFFSET(A1,1,2)
This points to the cell located one row below and two columns to the right of A1.
Build a rolling range
OFFSET is often used to define dynamic ranges for charts, summaries, or named ranges that need to expand and shift.
Common mistakes and notes
OFFSET is volatile
Like NOW, OFFSET recalculates frequently. In large workbooks that can add noticeable overhead.
It returns a reference
That is why OFFSET often appears inside other formulas or named ranges rather than standing alone as a final answer.