<div>
<div class="content wysiwyg-content">
In a previous questions <br />
<br />
<a href="https://www.experts-exchange.com/questions/27820774/excel-copy-contents-from-one-worksheet-column-to-another-worksheet.html" rel="ugc">https://www.experts-exchange.com/questions/27820774/excel-copy-contents-from-one-worksheet-column-to-another-worksheet.html</a>&nbsp;<br />
&nbsp;<br />
This was the lookup that solved that solution however I have two other needs:<br />
<br />
=IF(ISNA(VLOOKUP(A4,wBPS!A<wbr />:B, 2, FALSE) ),&quot;&quot;,VLOOKUP(A4,wBPS!A:B, 2, FALSE) )<br />
<br />
1. when the value in wBPS is blank I want text to say &quot;PPM/No BPS&quot;<br />
2. when there is no match in wBPS the text should say &quot;No PPM&quot;
</div>
</div>


In a previous questions 

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27820774.html 
 
This was the lookup that solved that solution however I have two other needs:

=IF(ISNA(VLOOKUP(A4,wBPS!A:B, 2, FALSE) ),"",VLOOKUP(A4,wBPS!A:B, 2, FALSE) )

1. when the value in wBPS is blank I want text to say "PPM/No BPS"
2. when there is no match in wBPS the text should say "No PPM"

More complicated Excel 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.