<div>
Use this formula, paste in C4 and copy down:<br />
<br />
=IF(ISNA(MATCH(B4,$A$4:$A$<wbr />300,0)),&quot;N<wbr />O&quot;,&quot;YES&quot;)<br />
<br />
Dave
</div>


Use this formula, paste in C4 and copy down:

=IF(ISNA(MATCH(B4,$A$4:$A$300,0)),"NO","YES")

Dave

<div>
Try:<br />
<br />

<pre><code id="code-20-36525748-1">=IF(ISERROR(MATCH(B4,$A$4:$A$300,0)),&quot;NO&quot;,&quot;YES&quot;)</code></pre>
</div>


Try:



=IF(ISERROR(MATCH(B4,$A$4:$A$300,0)),"NO","YES")

<div>
Pretty impressive - no answers when I started typing mine - accepted before I pressed submit - you can't hang around here
</div>


Pretty impressive - no answers when I started typing mine - accepted before I pressed submit - you can't hang around here

<div>
This formula is for cell C4:<br />
=IF(ISNA(MATCH(B4,A:A,0)),<wbr />&quot;No&quot;,&quot;Yes&quot;<wbr />)<br />
<br />
Copy C4 and select the range C5:C150, then paste.
</div>


This formula is for cell C4:
=IF(ISNA(MATCH(B4,A:A,0)),"No","Yes")

Copy C4 and select the range C5:C150, then paste.

<div>
andrewssd3 - I noticed :) &nbsp;I must have been a split second too slow, lol :)<br />
<br />
Dave
</div>


andrewssd3 - I noticed :)  I must have been a split second too slow, lol :)

Dave

<div>
Crap.. I'm sorry fellas. &nbsp;First one worked so I just accepted. &nbsp;I'm sure there is many ways to skin this cat :) &nbsp; I appreciate all the responses.
</div>


Crap.. I'm sorry fellas.  First one worked so I just accepted.  I'm sure there is many ways to skin this cat :)   I appreciate all the responses.

<div>
<div class="content wysiwyg-content">
I have text in Column A from rows 4 to 300 sorted alphabetically. &nbsp; I have text in column B from rows 4 to 150 sorted alphabetically. &nbsp; I need a formula in Column C that will look at the value in Column B and if it's found in Column A it says 'YES'. &nbsp;If not then 'NO'.
</div>
</div>


I have text in Column A from rows 4 to 300 sorted alphabetically.   I have text in column B from rows 4 to 150 sorted alphabetically.   I need a formula in Column C that will look at the value in Column B and if it's found in Column A it says 'YES'.  If not then 'NO'.

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.

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.