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:
I'm sure this is so simple but there you go!![]()
=Sheet1!A1
Thanks
dvent
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:
I'm sure this is so simple but there you go!![]()
=Sheet1!A1
Thanks
dvent
Last edited by dvent; 03-31-2010 at 11:36 AM.
You can use INDIRECT in either of the below forms
=INDIRECT("'"&A3&"'!R"&A1&"C"&A2,FALSE)
or
=INDIRECT(ADDRESS(A1,A2,,,A3))
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
brilliant thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks