If a1 is TRUE or omitted, ref_text is interpreted as an A1-style reference. If a1 is FALSE, ref_text is interpreted as an R1C1-style reference. Input the formula: =INDIRECT("$A$2"). Press Enter to get the result.