Comparing two xl sheets
Closed
vyk0522
Zohaib R
- Posts
- 2
- Registration date
- Tuesday February 12, 2013
- Status
- Member
- Last seen
- February 12, 2013
Zohaib R
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Related:
- Comparing two xl sheets
- Compare two excel sheets and highlight differences macro ✓ - Forum - Excel
- Vba code to compare two excel sheets and copy differences ✓ - Forum - Excel
- How to compare two Excel sheets with varying data ✓ - Forum - Excel
- Macro to compare 2 sheets and copy differences ✓ - Forum - Excel
- Comparing data between two excel sheets ✓ - Forum - Excel
3 replies
Zohaib R
Feb 12, 2013 at 07:36 AM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Feb 12, 2013 at 07:36 AM
Hi vyk0522,
I have uploaded a sample file which has Sheet 1, Sheet 2 and Sheet 3. Please check the below mentioned link and see if this file helps:
https://authentification.site/8avT2/Book1.xlsx
Please reply if you have any further questions.
I have uploaded a sample file which has Sheet 1, Sheet 2 and Sheet 3. Please check the below mentioned link and see if this file helps:
https://authentification.site/8avT2/Book1.xlsx
Please reply if you have any further questions.
vyk0522
Feb 12, 2013 at 07:45 AM
- Posts
- 2
- Registration date
- Tuesday February 12, 2013
- Status
- Member
- Last seen
- February 12, 2013
Feb 12, 2013 at 07:45 AM
hi Zohaib,
thanks a lot for your reply, but at office i could not access that link cos of security things.. could you please write it down the logic..
many thanks
thanks a lot for your reply, but at office i could not access that link cos of security things.. could you please write it down the logic..
many thanks
Zohaib R
Feb 12, 2013 at 08:27 AM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Feb 12, 2013 at 08:27 AM
Hi vyk0522,
Please arrange the values in the following order in Sheet 1 (col1Value01 is in A2 in and col2Value01 in B2):
col1 col2
col1Value01 col2Value01
col1Value02 col2Value02
col1Value03 col2Value03
col1Value04 col2Value04
col1Value05 col2Value05
col1Value06 col2Value06
col1Value07 col2Value07
col1Value08 col2Value08
col1Value09 col2Value09
col1Value10 col2Value10
col1Value11 col2Value11
col1Value12 col2Value12
In Sheet enter the following formula instead of first value of col1:
=Sheet1!A2
Drag and fill the remaining values in subsequent cells using Excel Fill Handle. The values should look like this (=Sheet1!A2 is in A2 of Sheet2 and col3Value01 is in B2):
col1 col3
=Sheet1!A2 col3Value01
=Sheet1!A3 col3Value02
=Sheet1!A4 col3Value03
=Sheet1!A5 col3Value04
=Sheet1!A6 col3Value05
=Sheet1!A7 col3Value06
=Sheet1!A8 col3Value07
=Sheet1!A9 col3Value08
=Sheet1!A10 col3Value09
=Sheet1!A11 col3Value10
=Sheet1!A12 col3Value11
=Sheet1!A13 col3Value12
In sheet 3 enter the following formulas and use Excel Fill Handle to fill the values in subsequent cells:
col1 col2 col3
=Sheet1!A2 =VLOOKUP(A2,Sheet1!$A$2:$B$13,2,0) =VLOOKUP(A2,Sheet2!$A$2:$B$13,2,0)
Please revert for clarification.
Please arrange the values in the following order in Sheet 1 (col1Value01 is in A2 in and col2Value01 in B2):
col1 col2
col1Value01 col2Value01
col1Value02 col2Value02
col1Value03 col2Value03
col1Value04 col2Value04
col1Value05 col2Value05
col1Value06 col2Value06
col1Value07 col2Value07
col1Value08 col2Value08
col1Value09 col2Value09
col1Value10 col2Value10
col1Value11 col2Value11
col1Value12 col2Value12
In Sheet enter the following formula instead of first value of col1:
=Sheet1!A2
Drag and fill the remaining values in subsequent cells using Excel Fill Handle. The values should look like this (=Sheet1!A2 is in A2 of Sheet2 and col3Value01 is in B2):
col1 col3
=Sheet1!A2 col3Value01
=Sheet1!A3 col3Value02
=Sheet1!A4 col3Value03
=Sheet1!A5 col3Value04
=Sheet1!A6 col3Value05
=Sheet1!A7 col3Value06
=Sheet1!A8 col3Value07
=Sheet1!A9 col3Value08
=Sheet1!A10 col3Value09
=Sheet1!A11 col3Value10
=Sheet1!A12 col3Value11
=Sheet1!A13 col3Value12
In sheet 3 enter the following formulas and use Excel Fill Handle to fill the values in subsequent cells:
col1 col2 col3
=Sheet1!A2 =VLOOKUP(A2,Sheet1!$A$2:$B$13,2,0) =VLOOKUP(A2,Sheet2!$A$2:$B$13,2,0)
Please revert for clarification.