Try something like this:

=INDEX(A:A,B2)

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"DrB" wrote in message
...
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?