OFFSET
Returns a reference offset from a given reference by a specified number of rows and columns.
| Category | Lookup |
| Syntax | OFFSET(reference, rows, cols, [height], [width]) |
Parameters
| Parameter | Required | Description |
|---|---|---|
reference | Required | The starting reference. |
rows | Required | The number of rows to offset (positive = down, negative = up). |
cols | Required | The number of columns to offset (positive = right, negative = left). |
height | Optional | The height (in rows) of the returned reference. |
width | Optional | The width (in columns) of the returned reference. |
Example
OFFSET(value, range, col)
Auto-generated from the EngCanvas function registry.