+ Reply to Thread
Results 1 to 3 of 3

Have Row & Column Number, and Sheet Name - Get Value

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    11-02-2007
    Location
    Leeds, England
    MS-Off Ver
    MS Office 2007
    Posts
    134

    Have Row & Column Number, and Sheet Name - Get Value

    Cell A1 = Row Number
    Cell A2 = Column Number
    Cell A3 = Sheet Name

    How do I add all of these together to get the value from a cell as you would with:

    =Sheet1!A1
    I'm sure this is so simple but there you go!

    Thanks
    dvent
    Last edited by dvent; 03-31-2010 at 11:36 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Have Row & Column Number, and Sheet Name - Get Value

    You can use INDIRECT in either of the below forms

    =INDIRECT("'"&A3&"'!R"&A1&"C"&A2,FALSE)

    or

    =INDIRECT(ADDRESS(A1,A2,,,A3))

  3. #3
    Forum Contributor
    Join Date
    11-02-2007
    Location
    Leeds, England
    MS-Off Ver
    MS Office 2007
    Posts
    134

    Re: Have Row & Column Number, and Sheet Name - Get Value

    brilliant thanks!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1