81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

Better Sheets
Create Free accountMember Login

OFFSET()

Description

Returns a range reference shifted a specified number of rows and columns from a starting cell reference.

How To Use in Sheets

OFFSET(cell_reference, offset_rows, offset_columns, [height], [width])

External Links

INDIRECT & OFFSET

Google Docs Help

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.