=IF(ISERROR(INDIRECT("'Worksheet AB'!B1")),0,INDIRECT("'Worksheet AB'!B1"))

Note the single quoation marks around the sheet name.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


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