 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2006How to get the answer to reference a worksheet
For example - if the answer to a calculation is 18, then look in sheet named "18". If 19, then look in sheet "19". Thanks. Marcus Use the INDIRECT function. E.g., =INDIRECT("'"&A1&"'"&"!A10") This will return the value in cell A10 from the sheet named in cell A1.  SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com > For example - if the answer to a calculation is 18, then look > in sheet named [quoted text clipped - 3 lines] > > Marcus |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.