Goal: Move from the Anchor (A1) to a target cell.
OFFSET moves: Down (Rows) and Right (Cols).
Ready...
💻 Formula Structure
=OFFSET(reference, rows, cols, [height], [width])
- 1. Reference: Starting point (Anchor).
- 2. Rows: How many rows to move down (+).
- 3. Cols: How many columns to move right (+).
-- Start at A1, Move to target
=OFFSET( A1, 0, 0 )
⚠️ Common Pitfalls
🚫 Volatile Function
OFFSET recalculates every time any cell changes. On large sheets, this causes lag.
✅ Fix: Use INDEX instead (it's non-volatile).
🚫 Moving Off-Grid
If you move Left or Up too far (negative numbers), you might go off the sheet edge (#REF!).