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.