Solved

Find an name in excel

Posted on 2012-12-20
2
177 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 33

Accepted Solution

by:
Norie earned 500 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

708 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now