=INDIRECT("B"&$A$5) returns the value of a reference in cell A5 : INDIRECT « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial





Input the formula: =INDIRECT("B"&$A$5). Press Enter to get the result.
Input the formula: =INDIRECT










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(