Compare to lists of names - ID those common to both files...

F

FrankRoman

New Member
Joined
Nov 6, 2002
Messages
9
Hello,
I have 2 Excel Files. One is a mailing list of members and includes the Member ID, and complete mailing address of the members. The other is a "flag file" which ONLY contains Member ID and Last name.

I want to "flag" (or identify) those on the Mailing List that are also on the Flag file".

Is there an easy way to do this?

Thanks for your help!

Frank Roman
 
Sort by date Sort by votes
Re: Compare to lists of names - ID those common to both file

You can use a Vlookup. This will return a match if they exist on the other list , otherwise #N/A.

With a bit of manipulation the N/A can be changed to some other flag if required.

Hope this helps
 
Upvote 0
Re: Compare to lists of names - ID those common to both file

Good morning, Frank.

See if any of these formulas can be adapted to your situation:
KEEPERS.xls
BCDEFGHIJK
3List1List2List3
4Compare:Compare:Compare:
5MastertoSubsSub1tolistSub2tolist
61onlist1and/orlist21onlist2onlist
72onlist1and/orlist23onlist3onlist
83onlist1and/orlist25onlist10onlist
94notoneither20notonlist26notonlist
105onlist1and/orlist225notonlist27notonlist
116notoneither7onlist
127onlist1and/orlist2
138notoneither
149notoneither
1510onlist1and/orlist2
MATCH-Compare lists
 
Upvote 0
Re: Compare to lists of names - ID those common to both file

Let A2:H100 house the mailing list and M2:N50 the flag-list.

In I2 enter & copy down:

=--ISNUMBER(MATCH(A2,$M$2:$M$50,0))

1 as result means that the member id in the mailing list is in the flag list, otherwise (0) it is not. You can by the way sum the I-range to obtain a count.
 
Upvote 0
You must log in or register to reply here.

Similar threads

Hrishi
  • Question Question
Slow file, Huge Name manager list
Replies
8
Views
299
jolivanes
jolivanes
L
  • Question Question
How to look up data from on sheet to another when both sheets have multiple cells with the same ID number.
Replies
5
Views
368
hagia_sofia
hagia_sofia
gmooney
  • Question Question
Connect Excel with Census.gov Population Data
Replies
5
Views
269
Rijnsent
Rijnsent
S
  • Question Question
Comparing Columns of names
Replies
5
Views
382
Zot
Z
L
  • Question Question
Macro to correct entries across multiple sheets
Replies
1
Views
308
Lux Aeterna
L

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top