One way:

=INDIRECT("A" & B2)

Another:

=INDEX(A:A,B2)



In article ,
"DrB" wrote:

Trying to have a cell read the number in another cell to come up with the
cell number from which the data is located, i.e., I have 25 in B2 and want
to read and show the data in A(the number in B2) or A25 in this case, but it
comes up with #name?. Am I doing it right?