cell referancing

drag-driver · Mar 29th, 2002, 06:35 AM

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 · Mar 29th, 2002, 06:57 AM

Quote:

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 · Mar 29th, 2002, 07:30 AM

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 29th, 2002, 06:35 AM	#1
drag-driver Board Regular Join Date: Feb 2002 Posts: 91	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

Mar 29th, 2002, 07:30 AM	#3
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,319	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)