<div>
Amazing can't believe I didn't try that.<br />
<br />
Thanks
</div>


Amazing can't believe I didn't try that.

Thanks

<div>
<div class="content wysiwyg-content">
Can an expert help me out with this please.<br />
<br />
I am using this formula<br />
<br />
=IF(VLOOKUP($A1,ADWR!A:B,2<wbr />,0)=&quot;R&quot;,J1<wbr />,K1) <br />
<br />
which works fine unless it can't find what it is looking for and then it returns #N/A<br />
<br />
Instead of N/A I need it to return Not Found<br />
<br />
but have been unsuccessful trying to use IFERROR and ISNA<br />
<br />
appreciate your help
</div>
</div>


Can an expert help me out with this please.

I am using this formula

=IF(VLOOKUP($A1,ADWR!A:B,2,0)="R",J1,K1) 

which works fine unless it can't find what it is looking for and then it returns #N/A

Instead of N/A I need it to return Not Found

but have been unsuccessful trying to use IFERROR and ISNA

appreciate your help

Problem with 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.