Indirect function help

[oyz79]

Hi, I have a spreadsheet which has the names of multiple sheets on the sheet1 along with several formulas on sheet1 which reference these different sheets. My objective is to write a formula which allows me to update the names of the sheets without rewriting all of my formulas on sheet1. I believe I need to use the "Indirect" function but don't have much experience with it.

In the example below, let's assume the name of sheet2 is also in cell A1 on sheet1 and the name of sheet3 is also in cell B1 on sheet1. How could I use the indirect function to rewrite the formula to reference cells A1 and B1 instead of the sheet names?

=PEARSON(sheet2!$J$5:$J$24,sheet3!J$5:J$24)

[:) Sixthsense :)]

Try this....

Please Login or Register  to view this content.