Returns the reference specified by a text string. Useful for building dynamic references.
=INDIRECT("B"&A1) if A1 contains 3, this returns the value of cell B3.
