<div>
<pre><code id="code-20-40927375-1">=IF(ISERROR(MATCH(A1,B:B,0)),&quot;&quot;,A1)</code></pre>
</div>


<div>
emmm, based on requirement, or:<br />
<br />

<pre><code id="code-20-40927383-1">=IF(ISERROR(MATCH(A1,B:B,0)),A1,&quot;&quot;)</code></pre>
?
</div>


emmm, based on requirement, or:



=IF(ISERROR(MATCH(A1,B:B,0)),A1,"")

?

<div>
Thanks so much for the help.
</div>


<div>
<div class="content wysiwyg-content">
I’m looking to format cell A3 to have the same value as A1 but if the value in A1 is the same as any cell in column B I want it to be blank. &nbsp;With this formula, =IF(A1=B1,&quot; &quot;,IF(A1&lt;&gt;B1,A1)) I can do it but only in the B1 cell not a range.
</div>
</div>


I’m looking to format cell A3 to have the same value as A1 but if the value in A1 is the same as any cell in column B I want it to be blank.  With this formula, =IF(A1=B1," ",IF(A1<>B1,A1)) I can do it but only in the B1 cell not a range.

MS Excel formula

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