Solved

Simple MATCH Formula? (with IF statement)

Posted on 2013-01-28
4
303 Views
Last Modified: 2013-01-28
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.
0
Comment
Question by:AliciaVee
  • 2
4 Comments
 
LVL 4

Expert Comment

by:MimicTech
Comment Utility
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")
0
 
LVL 26

Accepted Solution

by:
redmondb earned 500 total points
Comment Utility
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.

Regards,
Brian.Count-Found.xlsxCount-Found.xls
0
 

Author Closing Comment

by:AliciaVee
Comment Utility
Was exactly what I needed!
0
 
LVL 26

Expert Comment

by:redmondb
Comment Utility
Thanks, AliciaVee!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

771 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