Previous Topic Next Topic

Comparing two xl sheets

[Closed]
Report
Posts
2
Registration date
Tuesday February 12, 2013
Status
Member
Last seen
February 12, 2013
 -
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
 -
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

Answer 1 / 3
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
 45
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.
Answer 2 / 3
Posts
2
Registration date
Tuesday February 12, 2013
Status
Member
Last seen
February 12, 2013
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
Answer 3 / 3
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
 45
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.
Ask a question