Comparing data between two excel sheets
Solved/Closed
Related:
- Compare two excel sheets and highlight differences
- Excel date format dd.mm.yyyy - Guide
- How to screenshot excel sheet - Guide
- Beyond compare - Download - File management
- Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
- Mark sheet in excel - Guide
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
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
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
Dec 13, 2012 at 05:46 PM
Mar 19, 2014 at 05:14 AM
Mar 31, 2014 at 10:39 PM
Jun 10, 2014 at 02:52 PM
Dec 22, 2014 at 10:06 AM