Apple iWork Numbers Function Reference

INDIRECT

Description

The INDIRECT function returns a reference to an address specified as a string.

Syntax

INDIRECT(address, [style])

• address: A string representing a cell address or a reference to a cell that contains a cell address.
• style: Optional; address style used in address.
  

  TRUE, 1, or omitted indicates the A1 style address.
  FALSE or 0 returns an error indicating that the R1C1 style isn’t supported.

Examples