INDIRECT(ref_text,a1) returns a reference indicated by a text value : INDIRECT « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Lookup Reference functions
  3. INDIRECT
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.
Input the formula: =INDIRECT($A$2)








19.9.INDIRECT
19.9.1.INDIRECT(ref_text,a1) returns a reference indicated by a text valueINDIRECT(ref_text,a1) returns a reference indicated by a text value
19.9.2.=INDIRECT("$A$3") get the value of the reference in cell A3=INDIRECT(
19.9.3.=INDIRECT("B"&$A$5) returns the value of a reference in cell A5=INDIRECT(
19.9.4.Always refer to cell A10: =INDIRECT("A10")Always refer to cell A10: =INDIRECT(