Owner manual

INDIRECT

The INDIRECT function returns the contents of a cell or range referenced by an address

specied 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.