• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 365
  • Last Modified:

Simple MATCH Formula? (with IF statement)

Trying to create a match or Find formula to do the following:
Sheet 1 called: OriginalList
Column B has names

Sheet 2 (same workbook) called: NewList
Column A has names

Sheet 1 will have 1200 names
Sheet 2 has a subset of these names

I need to putinto Column A -- in Sheet 1 (original list) a YES, if the name is located in Sheet 2 and a No if the name isn't located in sheet 2

Caveat -- there may be dupes in sheet 2 -- it doesn't matter, would like a YES to appear, but in column D, the number of times that name appears in sheet 2.  It would always have a 0 if No is returned in sheet 1, because it didn't find the name in sheet 2.
  • 2
1 Solution
let's say data is all on one sheet (just for example - you can ref other sheet)

data in A1 - A10 = 0,1,2,3,4,5,6,7,8,9
data in C1 - C4 = 3,5,7,9

to put YES in col B1 - B10

formula -- =if(isna(match(A1,$C1:$C4,0)), "", "YES")
Hi, AliciaVee.

The attached assumes Excel 2007 or higher. Please let me know if you may use an earlier version.

Edit: The second file will also work with versions prior to Excel 2007.

AliciaVeeAuthor Commented:
Was exactly what I needed!
Thanks, AliciaVee!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

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