Skip to main content

DYNREF

Returns the value of a cell pointed to by a reference item

Syntax​

DYNREF(REF_CELL, CELL)

Arguments​

  • REF_CELL: The cell which contains the AnyDB Reference
  • CELL: The cell from which the value is to be returned from the reference

Example​

Assuming A1 contains an AnyDB reference with cell {{Greeting}} containing the value "Hello"
DYNREF(A1, {{Greeting}}) → Returns "Hello"

Notes​

DYNREF rewrites the formula expression internally at runtime, and this rewrite can only be performed once. As a result:

  • DYNREF calls cannot be nested.
  • DYNREF cannot be used inside another expression or function. It must be used by itself.

When you need to use multiple referenced values in an expression, perform each lookup separately, then combine the results. This is the recommended approach.