Formula to reference another worksheet

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?
 
S

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

SixBowls

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

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

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 -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top