OFFSET

OFFSET takes a starting cell and moves a given number of rows and columns from it, optionally returning a sized range. It powers dynamic ranges and rolling windows.

Excel

=OFFSET(A1, 2, 1)

Google Sheets

=OFFSET(A1, 2, 1)

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

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1A1 is the anchor cell.
22 moves down two rows; 1 moves right one column.
3Add height and width arguments to return a whole range, e.g. OFFSET(A1, 0, 0, 10, 1).

Need a version for your data?

Try: “Get the value two rows down and one column right of A1”

VLOOKUP XLOOKUP INDEX / MATCH

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

OFFSET

Try it with your data

How it works

Related