Comparing two excel sheets
Closed
kish1975
Posts
12
Registration date
Wednesday March 3, 2010
Status
Member
Last seen
March 22, 2010
-
Mar 4, 2010 at 02:32 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 4, 2010 at 05:36 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 4, 2010 at 05:36 AM
Related:
- Comparing two excel sheets
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Excel date format dd.mm.yyyy - Guide
- How to screenshot excel sheet - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- VBA Compare 2 sheets and output difference to 3rd sheet - Excel Forum
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Mar 4, 2010 at 05:36 AM
Mar 4, 2010 at 05:36 AM
in sheet 2 cell to the right of abc (that is in B2 ) copy paste this formula
=VLOOKUP(Sheet2!A2,Sheet1!$A$1:$C$4,3,0)
copy B2 down to any cell in column B of sheet 2.
=VLOOKUP(Sheet2!A2,Sheet1!$A$1:$C$4,3,0)
copy B2 down to any cell in column B of sheet 2.