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