OFFSET Function

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).