Formula to reference another worksheet

[SixBowls]

I have a macro that creates worksheets based on a list (tasks) on Sheet1. On
Sheet2 in column A, the worksheet has the same list of tasks. The formula on
Sheet2 cell A3 is ='Sheet1'$b$15. The result is "Maintenance" which is the
first task on Sheet1 and will be the first new worksheet the macro is run.

I would like cell B3 on Sheet2 to be ='Maintenance'$C$89. Is there anyway
to write a formula that will look at the result of A3 and let me use that for
the worksheet function?

 

[Pete_UK]

Try this in B3:

=INDIRECT("'"&A3&"'!C89")

Hope this helps.

Pete

 

[SixBowls]

Thanks! That works perfectly. Is there a way that it can return a 0 if the
sheet does not exist. Right now it is returning #REF!. I remeber using
ISERROR to fix a similar problem but I have not been able to get that to work.

 

[SixBowls]

I got the ISERROR to work. Thanks for the help!

=IF(ISERROR(INDIRECT("'"&A3&"'!C89")),0,INDIRECT("'"&A3&"'!C89"))

 

[Pete_UK]

Glad to hear it - thanks for feeding back.

Pete

I got the ISERROR to work.  Thanks for the help!

=IF(ISERROR(INDIRECT("'"&A3&"'!C89")),0,INDIRECT("'"&A3&"'!C89"))






- Show quoted text -