Report

Comparing data between two excel sheets [Solved/Closed]

Ask a question Annie - Last answered on Aug 18, 2017 at 08:23 AM by jsb pune
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!

Helpful
+188
plus moins
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
Was this answer helpful?  
RPatki- Dec 22, 2014 at 10:06 AM
Perfect. Thanks for the help.
chandru IB- Dec 27, 2014 at 12:51 PM
Thanks for the suggestion
Imra- Dec 31, 2014 at 09:01 AM
excellent...
Passer-by- May 2, 2017 at 02:25 PM
A simple, elegant solution. Thanks!
Reply
jsb pune- Aug 18, 2017 at 08:23 AM
Thanks Very helpfull
Reply
Helpful
+15
plus moins
Thank you Venkat1926, it worked and it is accurate.

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!