[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

Find an name in excel

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
cansevin
Asked:
cansevin
1 Solution
 
NorieVBA ExpertCommented:
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
 
cansevinAuthor Commented:
Thanks!
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now