<div>
If on Excel 2007 or later try this:<br />
<br />
=IFERROR(VLOOKUP(Z38,AK4:A<wbr />L15,2,FALS<wbr />E), &quot;&quot;)
</div>


If on Excel 2007 or later try this:

=IFERROR(VLOOKUP(Z38,AK4:AL15,2,FALSE), "")

<div>
You may simply use this...<br />

<pre><code id="code-20-42523148-1">=IF(Z38=&quot;&quot;,&quot;&quot;,IF(VLOOKUP(Z38,AK4:AL15,2,FALSE)=&quot;&quot;,&quot;&quot;,VLOOKUP(Z38,AK4:AL15,2,FALSE)))</code></pre>
OR this<br />

<pre><code id="code-20-42523148-2">=IF(Z38=&quot;&quot;,&quot;&quot;,VLOOKUP(Z38,AK4:AL15,2,FALSE))</code></pre>
<br />
Though another way is to wrap your formula with IFERROR like below but the disadvantage is in that case, the whole formula will be evaluated even if the Z38 is blank which is not required.<br />

<pre><code id="code-20-42523148-3">=IFERROR(VLOOKUP(Z38,AK4:AL15,2,FALSE),&quot;&quot;)</code></pre>
</div>


You may simply use this...


=IF(Z38="","",IF(VLOOKUP(Z38,AK4:AL15,2,FALSE)="","",VLOOKUP(Z38,AK4:AL15,2,FALSE)))

OR this


=IF(Z38="","",VLOOKUP(Z38,AK4:AL15,2,FALSE))


Though another way is to wrap your formula with IFERROR like below but the disadvantage is in that case, the whole formula will be evaluated even if the Z38 is blank which is not required.


=IFERROR(VLOOKUP(Z38,AK4:AL15,2,FALSE),"")

<div>
That was just what i needed. &nbsp;Thank you!
</div>


That was just what i needed.  Thank you!

<div>
<div class="content wysiwyg-content">
&quot;If statement&quot; results in a #N/A<br />
<br />
If cell Z38 = &quot;&quot;&nbsp;I want the result to be blank. &nbsp;If not blank it will place the proper value from the vlookup table. &nbsp;Formula works fine with a value. &nbsp;Empty &quot;Z38&quot; results in a #N/A.<br />
<br />
=IF(VLOOKUP(Z38,AK4:AL15,2<wbr />,FALSE)=&quot;&quot;<wbr />,&quot;&quot;,VLOOKU<wbr />P(Z38,AK4:<wbr />AL15,2,FAL<wbr />SE))
</div>
</div>


"If statement" results in a #N/A

If cell Z38 = "" I want the result to be blank.  If not blank it will place the proper value from the vlookup table.  Formula works fine with a value.  Empty "Z38" results in a #N/A.

=IF(VLOOKUP(Z38,AK4:AL15,2,FALSE)="","",VLOOKUP(Z38,AK4:AL15,2,FALSE))

&quot;If statement&quot; results in a #N/A

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

&quot;If statement&quot; results in a #N/A

"If statement" results in a #N/A