Hi,

Technically you can write a formula such as this.

=IF(ISERR(shane2!C6),0,shane2!C6)

It will show a result of 0 until Shane2 exists, then it will pick of the
value in that sheet. If you're worried about deleting sheets permanately
then it works also but the formula now show a #REF on the formula bar.

But if you are worried about deleting sheets and possible readding them then
don't use this formula because it will not be prepared when you add back the
sheet.

=IF(ISERR(INDIRECT("shane2!C6")),0,INDIRECT("shane 2!C6"))
or in 2007
=IFERROR(INDIRECT("shane2!C6"),0)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"wcurtis" wrote:

How can I use an IF function to look for a worksheet name and then look for a
specific cell and return the value in that cell. And if the worksheet is not
found, return a value of zero?
Example: Worksheet AB, cell B1, if not found return value of zero.