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
Hello,

I have two excel sheets. A and B
A has two columns col1 ,col2
B has two columns col1 and col3

i want create new sheet which has col1 , col2, col3..

how to do this?? please help me.. col1 ,col2,col3 has different rows..



3 replies

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 67
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.
0
vyk0522 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
0
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 67
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.
0