Spread Formula Reference
OFFSET
Formula Functions > Functions M to Q > OFFSET

This function returns a reference to a range. The range is a specified number of rows and columns from a cell or range of cells. The function returns a single cell or a range of cells.

Syntax

OFFSET(reference,rows,cols,height,width)

Remarks

This function has these arguments:.

Argument Description
reference The location from which to base the offset
rows Number of rows to which the upper left cell refers
cols Number of columns to which the upper left cell refers
height [Optional] Number of returned rows; if omitted, same as reference
width [Optional] Number of returned columns; if omitted, same as reference

The cols can be positive (right of the reference) or negative (left). If height or width is omitted, it is the same as the reference.

Remarks

This is a volatile function.

Data Types

Accepts a cell range for reference. Accepts numbers for rows, cols, height, and width. Returns a cell range.

Examples

OFFSET(D3,2,3,1,1)

OFFSET(D3:E5,2,3,1,1)

Version Available

This function is available in product version 2.5 or later.

See Also

HLOOKUP | LOOKUP | Lookup Functions