<div>
<div class="content wysiwyg-content">
In Column C I have a huge long list of about 22 names. On Sheet 2 Column C I have another list of 50 names. On the first sheet in column D, I would like the cell to say &quot;Yes&quot; If the name on the first sheet is also in the list of the 2nd sheet. If the name isn't in the 2nd sheet the result should be &quot;no&quot;. Any idea?
</div>
</div>


In Column C I have a huge long list of about 22 names. On Sheet 2 Column C I have another list of 50 names. On the first sheet in column D, I would like the cell to say "Yes" If the name on the first sheet is also in the list of the 2nd sheet. If the name isn't in the 2nd sheet the result should be "no". Any idea?

Find an name in excel

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