Apple iWork '09 - Manual (Page 216)

INDIRECT
The INDIRECT function returns the contents of a cell or range referenced by an address
specified as a string.
INDIRECT(addr-string, addr-style)
 addr-string: A string representing a cell address. addr-string is a string value.
 addr-style: An optional value specifying the address style.
A1 (TRUE, 1, or omitted): The address format should use letters for columns and
numbers for rows.
R1C1 (FALSE): The address format isn’t supported, returning an error.
Usage Notes
The given address can be a range reference, that is, “A1:C5”, not just a reference Â
to a single cell. If used this way, INDIRECT returns an array that can be used as
an argument to another function or directly read using the INDEX function. For
example, =SUM(INDIRECT(A1:C5, 1)) returns the sum of the values in the cells
referenced by the addresses in cells A1 through C5.
An address style of R1C1 is not supported and this modal argument is provided only
Â
for compatibility with other spreadsheet programs.
Example
If cell A1 contains 99 and A20 contains A1:
=INDIRECT(A20) returns 99, the contents of cell A1.
Related Topics
For related functions and additional information, see:
“INDEX” on page 214
“Listing of Reference Functions” on page 206
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
216 Chapter 9 Reference Functions