Comparing two xl sheets
Closed
vyk0522
Posts
2
Registration date
Tuesday February 12, 2013
Status
Member
Last seen
February 12, 2013
-
Feb 12, 2013 at 07:10 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Feb 12, 2013 at 08:27 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Feb 12, 2013 at 08:27 AM
Related:
- Comparing two xl sheets
- Sheets right to left - Guide
- Excel compare two sheets - Guide
- How to move between sheets in excel - Guide
- Little alchemy cheat sheets - Guide
- Macro to compare two excel sheets ✓ - Excel Forum
3 responses
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Feb 12, 2013 at 07:36 AM
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
Posts
2
Registration date
Tuesday February 12, 2013
Status
Member
Last seen
February 12, 2013
Feb 12, 2013 at 07:45 AM
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
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Feb 12, 2013 at 08:27 AM
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.