INDIRECT function


DESCRIPTION:

Returns the reference specified by a text string.

 

SYNTAX:

=INDIRECT( ref_text, [a1] )

 

REQUIRED ARGUMENTS:

ref_text

A boolean to indicate A1 or R1C1-style reference. The default is A1 style (TRUE).

 

OPTIONAL ARGUMENTS:

[a1]

The reference from which to extract information.