cell referancing

[drag-driver]

Want to create a cell referance like this,
A ref to a cell in with the row number given by a cell b3, something like this A(b3) where B3 is the row number, any ideas can it be done, whats the story with for loops can they run in excel.

thanks for the help
happy easter

 

[Amds]

On 2002-03-29 05:35, drag-driver wrote:
Want to create a cell referance like this,
A ref to a cell in with the row number given by a cell b3, something like this A(b3) where B3 is the row number, any ideas can it be done, whats the story with for loops can they run in excel.

thanks for the help
happy easter

=INDIRECT("A" & B3)

"whats the story with for loops can they run in excel" ......Yes.

 

[Aladin Akyurek]

Want to create a cell referance like this,
A ref to a cell in with the row number given by a cell b3, something like this A(b3) where B3 is the row number, any ideas can it be done, whats the story with for loops can they run in excel.


=INDIRECT("A" & B3)

And:

=OFFSET(A1,B3-1,0)