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