OFFSET

OFFSET an offset cell range

Synopsis

OFFSET(range,row,col,height,width)

Arguments

range: reference or range

row: number of rows to offset range

col: number of columns to offset range

height: height of the offset range, defaults to height of range

width: width of the offset range, defaults to width of range

Description

OFFSET returns the cell range starting at offset (row,col) from range of height height and width width.

Note

If range is neither a reference nor a range, OFFSET returns #VALUE!