software

I need to check from the Workbook1 whether the SheetName exists in the
Workbook2. (I have many workbooks to check.)
I'm trying to use
=IF(ISERROR('C:\[Workbook2.XLS]SheetName'!$A$1),quot;Noquot;,quot;Yesquot;)
It's working but if the SheetName has been created in the Workbook2 I have
#REF! in the Workbook1.

Probably, there is a better formula to do this.
Please, advise.

Thanks

If the other workbook is not open then you would need VBA for this, if it is
open

=IF(ISERROR(INDIRECT(quot;'[Workbook.xls]Sheet5'!$A$1quot;)),quot;Does Not
Existquot;,quot;Existquot;)
--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Alexquot; gt; wrote in message
...
gt;I need to check from the Workbook1 whether the SheetName exists in the
gt; Workbook2. (I have many workbooks to check.)
gt; I'm trying to use
gt; =IF(ISERROR('C:\[Workbook2.XLS]SheetName'!$A$1),quot;Noquot;,quot;Yesquot;)
gt; It's working but if the SheetName has been created in the Workbook2 I have
gt; #REF! in the Workbook1.
gt;
gt; Probably, there is a better formula to do this.
gt; Please, advise.
gt;
gt; ThanksThanks Peo,
Unfortunately, all those workbooks I need to look at regarding a specific
sheet are closed.
Can we use something with VLOOKUP to find there something very common such
as an empty cell or whaterver?
I tried =VLOOKUP(quot;quot;,[Workbook.XLS]SheetName!$A$1:$A$100,1,TRUE)
but, it's not working. This quot;quot; is not valid.

quot;Peo Sjoblomquot; wrote:

gt; If the other workbook is not open then you would need VBA for this, if it is
gt; open
gt;
gt; =IF(ISERROR(INDIRECT(quot;'[Workbook.xls]Sheet5'!$A$1quot;)),quot;Does Not
gt; Existquot;,quot;Existquot;)
gt;
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Alexquot; gt; wrote in message
gt; ...
gt; gt;I need to check from the Workbook1 whether the SheetName exists in the
gt; gt; Workbook2. (I have many workbooks to check.)
gt; gt; I'm trying to use
gt; gt; =IF(ISERROR('C:\[Workbook2.XLS]SheetName'!$A$1),quot;Noquot;,quot;Yesquot;)
gt; gt; It's working but if the SheetName has been created in the Workbook2 I have
gt; gt; #REF! in the Workbook1.
gt; gt;
gt; gt; Probably, there is a better formula to do this.
gt; gt; Please, advise.
gt; gt;
gt; gt; Thanks
gt;
gt;