Pasting along a row, across columns - just use the Index() formula with an
absolute revision to B2:

=INDEX(A:A,$B$2)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
\
"DrB" wrote in message
...
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?