Comparing data between two excel sheets

Solved/Closed
Annie - Sep 23, 2010 at 12:33 AM
 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!

Related:

2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 20, 2010 at 06:03 AM
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
184
You're brilliant...thanks!!!
0
i got a one more error . as above I tried but not came.is there any one to help me
0
This make no sense, I need this explained a bit more please!
0
Worked perfectly!!!
0
Perfect. Thanks for the help.
0
Thank you Venkat1926, it worked and it is accurate.
15