Spread Formula Reference
Formula Functions / Functions M to Q / OFFSET
In This Topic
    OFFSET
    In This Topic

    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