OFFSET

Returns a reference to a range that is the specified number of rows and columns from the specified cell or range of cells. The reference that is returned can be a single cell or a range of cells, according to the specified number of rows and columns.

Syntax

OFFSET( Reference r, Integer rows, Integer columns, [Integer height], [Integer width] ) → Reference

Parameters

r

Required. The reference that should be offset.

rows

Required. The row of the new reference, relative to r.

columns

Required. The column of the new reference, relative to r.

height

Optional. The height, in number of rows, of the new reference. Must be a positive number.

width

Optional. The width, in number of columns, of the new reference. Must be a positive number.

Remarks

If r does not identify a valid cell or cell range, the function returns the #REF! error value. If the new reference goes over the edge of the worksheet, OFFSET returns the #REF! error value. If the specified values are not integer, they are automatically truncated.

If height or width is omitted, the new reference is assumed to be the same height or width as r.

Example

Formula

=OFFSET(E6,-2,-2)
=OFFSET(A1:C3,2,3,,5)

See Also

Function Reference
COLUMN Function
COLUMNS Function
ROW Function
ROWS Function