M Marcus Fox Jun 12, 2006 #1 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
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
C Chip Pearson Jun 12, 2006 #2 Use the INDIRECT function. E.g., =INDIRECT("'"&A1&"'"&"!A10") This will return the value in cell A10 from the sheet named in cell A1. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Marcus Fox" <[email protected]> wrote in message news:[email protected]...
Use the INDIRECT function. E.g., =INDIRECT("'"&A1&"'"&"!A10") This will return the value in cell A10 from the sheet named in cell A1. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Marcus Fox" <[email protected]> wrote in message news:[email protected]...