Question description:
This user has given permission to use the problem statement for this
blog.
Hello,
I have a 4000+ list of emails, I need excel to scan through a different list( this one containing duplicates) and then indicate individually if each of the 4000+ emails are listed in the other list.
Solved by G. H. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
04/06/2018 - 05:59
Hi…Welcome to Got It Pro
User
04/06/2018 - 05:59
Hello!
Excelchat Expert
04/06/2018 - 06:00
Could you please share a sample of your data so that I can create the formula?
User
04/06/2018 - 06:01
So, just to clarify, one sheet has 4000ish emails, the other 800 with duplicates.
User
04/06/2018 - 06:02
My goal is to somehow indicate individually if the emails on the 4000, are also listed in the 800 without having to manually read through them
Excelchat Expert
04/06/2018 - 06:02
So can we assume Sheet 1 as duplicates and Sheet2 as the Master with 4000+
User
04/06/2018 - 06:02
The reverse
Excelchat Expert
04/06/2018 - 06:02
ok
Excelchat Expert
04/06/2018 - 06:03
So let me do the formula in Sheet 2 to lookup Sheet 1 and see if any email from Sheet 2 is in Sheet 1.
Excelchat Expert
04/06/2018 - 06:03
Will that be correct?
User
04/06/2018 - 06:04
So, I need the reverse. I need to see if any emails in sheet 2 are in sheet 1.
User
04/06/2018 - 06:04
This is because after I figure this out, there will be more sheets to compare sheet 1 too, with different emails
Excelchat Expert
04/06/2018 - 06:07
I have placed a Yes if the email exist in Sheet1
Excelchat Expert
04/06/2018 - 06:07
Is that what you were looking for?
User
04/06/2018 - 06:08
Sorry, if I am doing a bad job explaining. If i want to place a Yes (Under sheet 1) if the email exist on sheet 2, can i just switch around the range?
Excelchat Expert
04/06/2018 - 06:08
Yes, you can
Excelchat Expert
04/06/2018 - 06:09
You can replicate the same formula and just alter the range
User
04/06/2018 - 06:09
Okay, perfect. Thank you!
Excelchat Expert
04/06/2018 - 06:09
Is there anything else I can help you with this query?
User
04/06/2018 - 06:09
Nope, this is all. Thanks again!
Excelchat Expert
04/06/2018 - 06:10
Perfect...Please do give me a good feedback for my service.
Excelchat Expert
04/06/2018 - 06:10
Thanks for your time. Please do come back for any new question. Have a great day ahead!
User
04/06/2018 - 06:10
Will do
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.