OFFSET Function
- OFFSET( <value>, <periods> )
Gets the value offset by the specified number of periods.
| Function Parameters | |
|---|---|
| Parameter | Description |
| <value> | The value to look up. |
| <periods> | The number of periods to look back or forward. |
Note: A negative <periods> value retrieves previous values, whereas a positive <periods> retrieves forward values (looks ahead).