INDIRECT(ref_text,format)
ref_text: textual reference
format: if true, ref_text is given in A1-style, otherwise it is given in R1C1 style; defaults to true
If ref_text is not a valid reference in the style determined by format, INDIRECT returns #REF!