That works. Thanks to everyone.

Now I want to paste into cells but keep B2 the same and allow A to change as
I paste along the row. I tried =indirect(A&"B2") but did not work. Can it be
done?

"Elkar" wrote in message
...
No, as you have it, Excel is looking for a function called A. Try using
the
INDIRECT function:

=INDIRECT("A"&B2)

HTH,
Elkar


"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?