Matching Two Files Hello I have two lists of data that i need to match. Sheet 1
ID: 643223 • Letter: M
Question
Matching Two Files
Hello
I have two lists of data that i need to match. Sheet 1 includes a list of unique identifiers (email addresses) of customers. Sheet 2 Includes a list of unique identifiers (email addresses) of people who came into our chat room for discussions. I want to find a match between these two lists.
Example:
Sheet 1
Email Address 1
Email Address 2
Email Address 3
Email Address 4
Email Address 5
Email Address 6
Sheet 2
Email Address 9
Email Address 15
Email Address 22
Email Address 3
Email Address 55
Email Address 4
Email Address 5
I would like Excel to spit out a match of these two lists. As you can see, Sheet 2 has 3 matches to Sheet 1. I would like the report to look like this:
Sheet 1 Match?
Email Address 1 No
Email Address 2 No
Email Address 3 Yes
Email Address 4 Yes
Email Address 5 Yes
Email Address 6 No
Can you help???
Thanks !!
Explanation / Answer
Assume that data starts at Cell A1, then type the following in B1
=IF(ISNA(VLOOKUP(A1,Sheet2!$A$1:$A$7,1,0)),"No","Yes")