Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Row Column Refrence

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    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))


  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    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

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •