Row Column Refrence

[bdennis5]

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]

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]

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]

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]

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