Use a cell reference to point to a sheet name in a formula

[jpwbvi]

Is there a way to use a cell reference to populate a sheet name reference in a formula? For example:


I have a formula: =SUM('May-Oct'!$C$2:$C$30000). I would like to replace the 'May-Oct' with a cell value.

 

[vijaySharma]

You can use the below to get this done...

[pre]

=SUM(INDIRECT(E2&"$C$2:$C$30000"))

[/pre]

Cell E2 contains the text that you want to replace, and should be a sheet name else you will get error in the formula.


~VijaySharma

 

[jpwbvi]

Excellent - works perfectly, thx!