INDIRECT function


Returns the reference specified by a text string.



=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.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.