indirect

Reference resolved from a text string.

Syntax

v = indirect(ref_text, a1)

Description

Returns the value of the cell or range whose address is given as the text ref_text. With a1 = true (default), interprets the text as A1 notation; with false, as R1C1 notation.

Use with care: indirect references break formula auditing and recalculation tracking.

Examples

indirect('A1')           % value at A1
indirect('Sheet2!B'+row)

See also

• address — Cell address as a text string.
• offset — Reference offset by rows and columns.