INDIRECT

Returns the cell specified by a text string.
A1: =INDIRECT("C1") => 8
A2: =INDIRECT("D"&4) => 6
A3: =INDIRECT("E"&ROW()) => 3
A4: =SUM(INDIRECT("$C$4:$E$4")) => 12
A5: =INDIRECT(NAMED_RANGE_FOR_CELL_D4) => 6