You could use something like this

=IF(ISERROR(Sheet8!B1),0,Sheet8!B1)

But that would mask all errors.

i.e. you might have the correct sheet but if B1 contains an error you will
still get a 0


Gord Dibben MS Excel MVP




On Thu, 8 Jan 2009 12:49:02 -0800, 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.