Comparing data between two excel sheets [Solved/Closed]

- - 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 

2 replies

Best answer
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
183
Thank you
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

Say "Thank you" 183

A few words of thanks would be greatly appreciated. Add comment

CCM has helped 2730 users this month

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
Thank you
Thank you Venkat1926, it worked and it is accurate.