<div>
but ISERROR formula evaluates value inside formula and gives you TRUE or FALSE.<br />
what if you try just:<br />
<b>=IF(R154=&quot;No Match&quot;,VLOOKUP(AK154,X:AB,<wbr />5,0),&quot;Not Found&quot;)</b><br />
<br />
or you can attach excel sample<br />
<br />
PS: also could be:<br />
=IF(R154=&quot;No Match&quot;,VLOOKUP(AK154,$X:$A<wbr />B,5,0),&quot;No<wbr />t Found&quot;)
</div>


but ISERROR formula evaluates value inside formula and gives you TRUE or FALSE.
what if you try just:
=IF(R154="No Match",VLOOKUP(AK154,X:AB,5,0),"Not Found")

or you can attach excel sample

PS: also could be:
=IF(R154="No Match",VLOOKUP(AK154,$X:$AB,5,0),"Not Found")

<div>
helpfinder<br />
<br />
That returns N/A
</div>


<div>
I changed it to <br />
<br />
=IFERROR(IF(R154=&quot;No Match&quot;,VLOOKUP(AK154,X:AB,<wbr />5,0),&quot;&quot;),&quot;<wbr />Not Found&quot;)<br />
<br />
and it is exactly what I needed <br />
<br />
Thanks
</div>


I changed it to

=IFERROR(IF(R154="No Match",VLOOKUP(AK154,X:AB,5,0),""),"Not Found")

and it is exactly what I needed

Thanks

<div>
<div class="content wysiwyg-content">
I am doing a VLookup with an IF an the result it is returning is True. What I am trying to dai is say <br />
<br />
If R2 is = No Match Lookup AK2 in the range A:AB column 5 if found return the answer but if it's not there I want it to return Not Found<br />
<br />
=ISERROR(IF(R154=&quot;No Match&quot;,VLOOKUP(AK154,X:AB,<wbr />5,0),&quot;Not Found&quot;))<br />
<br />
What am I doing wrong?<br />
<br />
Thanks in advance
</div>
</div>


I am doing a VLookup with an IF an the result it is returning is True. What I am trying to dai is say 

If R2 is = No Match Lookup AK2 in the range A:AB column 5 if found return the answer but if it's not there I want it to return Not Found

=ISERROR(IF(R154="No Match",VLOOKUP(AK154,X:AB,5,0),"Not Found"))

What am I doing wrong?

Thanks in advance

error with Vlookup

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