Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Lookup Reference Functions

 

=INDIRECT(B&$A$5) returns the value of a reference in cell A5

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