Formula to reference another worksheet

  • Thread starter Thread starter SixBowls
  • Start date Start date
S

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?
 
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.
 
I got the ISERROR to work. Thanks for the help!

=IF(ISERROR(INDIRECT("'"&A3&"'!C89")),0,INDIRECT("'"&A3&"'!C89"))
 
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 -
Click to expand...
 
Back
Top