<div>
Try:<br />
<br />
=IF($A$1&lt;&gt;Data!A4,&quot;&quot;,IF(IS<wbr />ERROR(FIND<wbr />($A$1,Data<wbr />!D4)),&quot;&quot;,D<wbr />ata!A4))
</div>


Try:

=IF($A$1<>Data!A4,"",IF(ISERROR(FIND($A$1,Data!D4)),"",Data!A4))

<div>
I still get a 'zero'. &nbsp;Researching this further...thanks for your help, though.
</div>


I still get a 'zero'.  Researching this further...thanks for your help, though.

<div>
Hi there, not sure if this is resolved yet but you may want to check out your settings.<br />
<br />
Depending on what version of Excel you have, go to File-&gt;Options-&gt;Advanced. <br />
In the dialog box that pops up, go to 'Show zero in cells that have a zero value' and uncheck it.<br />
<br />
Cheers,<br />
Tony
</div>


Hi there, not sure if this is resolved yet but you may want to check out your settings.

Depending on what version of Excel you have, go to File->Options->Advanced.
In the dialog box that pops up, go to 'Show zero in cells that have a zero value' and uncheck it.

Cheers,
Tony

<div>
Thank you for your input. &nbsp;The problem was that the cells were never blank since they had a formula in them! &nbsp;Have rescoped how things were happening and it seems o.k. now...can we close this one?
</div>


Thank you for your input.  The problem was that the cells were never blank since they had a formula in them!  Have rescoped how things were happening and it seems o.k. now...can we close this one?

<div>
<div class="content wysiwyg-content">
Hi Experts:<br />
I have this formula on cells in my spreadsheet:<br />
=IF($A$1=&quot;ALL&quot;,Data!A4,IF(<wbr />ISERROR(FI<wbr />ND($A$1,Da<wbr />ta!D4)),&quot;&quot;<wbr />,Data!A4))<wbr /><br />
<br />
The spreadsheet contains a value in A1 which can vary. &nbsp;The data as you can see comes from another spreadsheet. &nbsp;If the A1 value does not match the Data spreadsheet D4 cell, I want a blank or null. &nbsp;Now I am getting zeros when there is no match.<br />
<br />
I hope this makes sense.<br />
<br />
Thank you.
</div>
</div>


Hi Experts:
I have this formula on cells in my spreadsheet:
=IF($A$1="ALL",Data!A4,IF(ISERROR(FIND($A$1,Data!D4)),"",Data!A4))

The spreadsheet contains a value in A1 which can vary.  The data as you can see comes from another spreadsheet.  If the A1 value does not match the Data spreadsheet D4 cell, I want a blank or null.  Now I am getting zeros when there is no match.

I hope this makes sense.

Thank you.

Excel ISERROR question

Apache Flex is a highly productive, open source application framework for building and maintaining expressive web applications that deploy consistently on all major browsers, desktops and devices (including smartphones, tablets and television). It provides a modern, standards-based language and programming model that supports common design patterns suitable for developers from many backgrounds. Flex applications can be deployed to the Adobe Player in the browser, Adobe AIR on desktop and mobile devices or to native Android, iOS, Windows or Mac applications.

Apache Flex

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.