<div>
=IF(ISNA(VLOOKUP(J4,$D$3:$<wbr />D$4000,1,F<wbr />ALSE)),&quot; New Part &quot;,&quot;&quot;)
</div>


=IF(ISNA(VLOOKUP(J4,$D$3:$D$4000,1,FALSE))," New Part ","")

<div>
<div class="content wysiwyg-content">
=IF(VLOOKUP(J4,$D$3:$D$400<wbr />0,1,FALSE)<wbr />&gt;0,&quot;&quot;,&quot; New Part &quot;)<br />
<br />
The formula works, but the return is the error #N/A. &nbsp;Would prefer it to say &quot;new part&quot;
</div>
</div>


=IF(VLOOKUP(J4,$D$3:$D$4000,1,FALSE)>0,""," New Part ")

The formula works, but the return is the error #N/A.  Would prefer it to say "new part"

Why does my formula not return the words &quot;new part&quot;

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

Why does my formula not return the words &quot;new part&quot;

Why does my formula not return the words "new part"