=INDIRECT("$A$3") get the value of the reference in cell A3 : INDIRECT « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial






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