Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Lookup Reference Functions

 

=INDIRECT($A$3) get the value of the reference in cell A3

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