Comparing two xl sheets
Closed
vyk0522
Posts
2
Registration date
Tuesday 12 February 2013
Status
Member
Last seen
12 February 2013
-
12 Feb 2013 à 07:10
Zohaib R Posts 2368 Registration date Sunday 23 September 2012 Status Member Last seen 13 December 2018 - 12 Feb 2013 à 08:27
Zohaib R Posts 2368 Registration date Sunday 23 September 2012 Status Member Last seen 13 December 2018 - 12 Feb 2013 à 08:27
Related:
- Comparing two xl sheets
- Google sheets right to left - Guide
- Vba sheets add - Guide
- Google sheets download - Download - Spreadsheets
- Compare data in two excel sheets - Guide
- Little alchemy cheat sheets - Guide
3 responses
Zohaib R
Posts
2368
Registration date
Sunday 23 September 2012
Status
Member
Last seen
13 December 2018
69
12 Feb 2013 à 07:36
12 Feb 2013 à 07:36
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 12 February 2013
Status
Member
Last seen
12 February 2013
12 Feb 2013 à 07:45
12 Feb 2013 à 07:45
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 23 September 2012
Status
Member
Last seen
13 December 2018
69
12 Feb 2013 à 08:27
12 Feb 2013 à 08:27
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.
