Row Column Refrence

bdennis5 · Mar 26th, 2002, 10:26 AM

Formula X = Row Number 1
Formula Y = Column Number 2

I put these togather(X&Y) and get 12. What I want to do is make it look at R1C2. How do I do this?

Aladin Akyurek · Mar 26th, 2002, 10:28 AM

Quote:

On 2002-03-26 09:26, bdennis5 wrote:
Formula X = Row Number 1
Formula Y = Column Number 2

I put these togather(X&Y) and get 12. What I want to do is make it look at R1C2. How do I do this?

Do you mean:

=INDIRECT(ADDRESS(1,2))

bdennis5 · Mar 26th, 2002, 10:45 AM

Yes that dose it...Now if I am on Sheet1 and want the range to look at Sheet2 what would I need to do. Right now it is looking at the current sheet the formula is in.

Thanks for the Help,
Bobby

Aladin Akyurek · Mar 26th, 2002, 10:49 AM

Quote:

On 2002-03-26 09:45, bdennis5 wrote:
Yes that dose it...Now if I am on Sheet1 and want the range to look at Sheet2 what would I need to do. Right now it is looking at the current sheet the formula is in.

Thanks for the Help,
Bobby

=INDIRECT("Sheet2!"&ADDRESS(1,2))

You may even have Sheet2 in a cell, say, E1 as name, then use:

=INDIRECT(E1&"!"&ADDRESS(1,2))

Aladin

bdennis5 · Mar 26th, 2002, 10:56 AM

Aladin,
Thank you very much..It works great.

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

Mar 26th, 2002, 10:26 AM	#1
bdennis5 New Member Join Date: Mar 2002 Posts: 10	Formula X = Row Number 1 Formula Y = Column Number 2 I put these togather(X&Y) and get 12. What I want to do is make it look at R1C2. How do I do this?

Mar 26th, 2002, 10:45 AM	#3
bdennis5 New Member Join Date: Mar 2002 Posts: 10	Yes that dose it...Now if I am on Sheet1 and want the range to look at Sheet2 what would I need to do. Right now it is looking at the current sheet the formula is in. Thanks for the Help, Bobby

Mar 26th, 2002, 10:56 AM	#5
bdennis5 New Member Join Date: Mar 2002 Posts: 10	Aladin, Thank you very much..It works great.