Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Find an name in excel

Posted on 2012-12-20
2
Medium Priority
?
253 Views
Last Modified: 2012-12-20
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?
0
Comment
Question by:cansevin
2 Comments
 
LVL 35

Accepted Solution

by:
Norie earned 2000 total points
ID: 38711593
Put this in column D on Sheet1 and copy down.

=IF(ISNUMBER(MATCH(C2, Sheet2!C2:C51, 0), "Yes", "No")

Note, I've assumed the first row of data on both sheets is row 2.
0
 

Author Closing Comment

by:cansevin
ID: 38711725
Thanks!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question