Comparing data between two excel sheets [Solved/Closed]

Annie - Sep 23, 2010 at 12:33 AM - Latest reply:  dubla89
- Dec 1, 2017 at 07:11 AM
Hello,

I have two excel sheets with the same columns. Essentially Name, Email, Phone. One sheet is the 'original" data and the other is the "updated" data which may contain additions or deletions of names, and/or changes in email address, phone, etc.

How do I generate a list of "changes" - essentially differences in sheet 2 compared to sheet 1. For example, A list of changed emails by name? A list of names on sheet 2 that do not appear on sheet 1?

Thanks!

See more 

12 replies

venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus March 10, 2016 Last seen - Dec 20, 2010 at 06:03 AM
+184
Helpful
10
suppose sheet 1 is
name email phone
a
d
g


sheet 2 is
name email phone
A
S
D
F
G
H
J
K


in sheet 2 in D2 copy this formula

=VLOOKUP(A2,Sheet1!$A$2:$C$101,1,0)
copy the formula in D2 down. wherever the data is not available in sheet will show #N/A

You can modify this solution to suit your needs
Thanks for the suggestion
A simple, elegant solution. Thanks!
Thanks Very helpfull
this is great,perfect! I also managed to add a "*AND" function to find anyone with either first and last name columns that were either incorrect or missing.

example:
=VLOOKUP(A2,Sheet1!$A$2:$A$101,1,0)*AND(B2,Sheet1!$B$2:$B$101,1,0)
+15
Helpful
Thank you Venkat1926, it worked and it is accurate.