How to get the answer to reference a worksheet

[Marcus Fox]

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

 

[Chip Pearson]

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]...