OFFSET

Summary

OFFSET is volatile and returns a reference that can point to a single cell or a resized range, depending on the optional height and width arguments.

Remarks

• rows and cols shift from the top-left of reference.
• If omitted, height and width default to the original reference size.
• Non-positive target coordinates or dimensions return #REF!.
• Non-numeric offset/size inputs return #VALUE!.
• In value context, a 1x1 result returns a scalar; larger results spill as an array.

Examples

Related functions

• INDEX
• INDIRECT
• ADDRESS
• ARRAYTOTEXT
• CHISQ.DIST
• CONFIDENCE.NORM

FAQ

What defaults are used when height and width are omitted?

OFFSET keeps the source reference size, then applies the row/column shift to that same-sized block.

When does OFFSET return #REF!?

It returns #REF! if the shifted start goes to row/column <= 0 or if requested height/width are non-positive.

Runtime metadata