# OFFSET

## Content

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])`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *reference* | [Required] The location from which to base the offset |
| *rows* | [Required] Number of rows to which the upper-left cell refers |
| cols | [Required] 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.

## Examples

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