Merging two columns in two different excel sheets

[deck99]

i have 2 sheets. First sheet contains 3 columns(A,B,C) and second sheet contains 4 columns A,B,C,D, Column A is common in both the sheets. Please refer the foolowing exaxmple
Sheet1 Sheet2
A B C A B C D
1 PL O 1 K 3.5 8
1 LC U 1 J 2 5
1 MN H
1 BV G
1 VB D

i WANT LIKE THIS IN SHEET 1
A B C D
1 PL O K
1 MN H J
1 BV G
1 VB D

 

[jarjarbingie]

i have 2 sheets. First sheet contains 3 columns(A,B,C) and second sheet contains 4 columns A,B,C,D, Column A is common in both the sheets. Please refer the foolowing exaxmple
Sheet1 Sheet2
A B C A B C D
1 PL O 1 K 3.5 8
1 LC U 1 J 2 5
1 MN H
1 BV G
1 VB D

i WANT LIKE THIS IN SHEET 1
A B C D
1 PL O K
1 MN H J
1 BV G
1 VB D

just a clarification though, where did the 2nd row in sheet 1 go?

 

[deck99]

Sheet 1 consists of:
Sheet1 Sheet2
A B C
1 PL O
1 LC U
1 MN H
1 BV G
1 <acronym title="vBulletin" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); font-style: italic; background-color: rgb(242, 246, 248); ">VB</acronym> D

Sheet2 contains
A B C D
1 K 3.5 8
1 J 2 5

i want in Sheet1 where column b of sheets is merged with matching column A in sheet1
A B C D
1 PL O K
1 MN H J
1 BV G
1 <acronym title="vBulletin" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); font-style: italic; background-color: rgb(242, 246, 248); ">VB</acronym> D

 

[jarjarbingie]

Sheet 1 consists of:
Sheet1 Sheet2
A B C
1 PL O
1 LC U
1 MN H
1 BV G
1 <acronym title="vBulletin" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); font-style: italic; background-color: rgb(242, 246, 248); ">VB</acronym> D

Sheet2 contains
A B C D
1 K 3.5 8
1 J 2 5

i want in Sheet1 where column b of sheets is merged with matching column A in sheet1
A B C D
1 PL O K
1 MN H J
1 BV G
1 <acronym title="vBulletin" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); font-style: italic; background-color: rgb(242, 246, 248); ">VB</acronym> D

where is the row where we have 1 LC U in Sheet1 originally? and how do we map the rows? column A cannot be used since they are all 1s..

 

[deck99]

Sorry please check now

Sheet 1 consists of:
Sheet1 Sheet2
A B C
1 PL O
1 LC U
1 MN H
1 BV G
1 <acronym title="vBulletin" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); font-style: italic; background-color: rgb(242, 246, 248); ">VB</acronym> D

Sheet2 contains
A B C D
1 K 3.5 8
1 J 2 5

i want in Sheet1 where column b of sheets is merged with matching column A in sheet1
A B C D
1 PL O K
1 LC U J
1 MN H
1 BV G
1 <acronym title="vBulletin" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); font-style: italic; background-color: rgb(242, 246, 248); ">VB</acronym> D

 

[jarjarbingie]

Sorry please check now

Sheet 1 consists of:
Sheet1 Sheet2
A B C
1 PL O
1 LC U
1 MN H
1 BV G
1 <acronym title="vBulletin" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); font-style: italic; background-color: rgb(242, 246, 248); ">VB</acronym> D

Sheet2 contains
A B C D
1 K 3.5 8
1 J 2 5

i want in Sheet1 where column b of sheets is merged with matching column A in sheet1
A B C D
1 PL O K
1 LC U J
1 MN H
1 BV G
1 <acronym title="vBulletin" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); font-style: italic; background-color: rgb(242, 246, 248); ">VB</acronym> D

in Sheet1 cell D2, type:
= IF(Sheet2!B2="","",Sheet2!B2)
then drag down

 

[deck99]

i have a sheets of 10000 rows where there are different rows value in column A in sheet1. i want it dynamic

 

[jarjarbingie]

i have a sheets of 10000 rows where there are different rows value in column A in sheet1. i want it dynamic

ok, but how do we match the rows? as I have mentioned earlier, it is not possible to use column A since in the sample you gave, it is not unique..

 

[deck99]

any other way