search and merge data from two sheets

[iris1007]

Hi,　

I have difference info from Sheet1 & Sheet2 and I need to combine them into Sheet3.

[TABLE="width: 354"]
<tbody>[TR]
[TD]sheet1[/TD]
[TD][/TD]
[TD][/TD]
[TD]sheet2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Item[/TD]
[TD]Reading[/TD]
[TD][/TD]
[TD]Item[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]China[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]70[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]Hong Kong[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]51[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]Taiwan[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]45[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]Australia[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD]B[/TD]
[TD]Korea[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD]B[/TD]
[TD]USA[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]48[/TD]
[TD][/TD]
[TD]B[/TD]
[TD]Japan[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]142[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]Iceland[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]21[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]England[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]77[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]Thailand[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]Norway[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]64[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]India[/TD]
[/TR]
</tbody><colgroup><col span="4"><col></colgroup>[/TABLE]


[TABLE="width: 157"]
<tbody>[TR]
[TD]sheet3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Reading[/TD]
[/TR]
[TR]
[TD]China[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]China[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD]China[/TD]
[TD="align: right"]51[/TD]
[/TR]
[TR]
[TD]China[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]Hong Kong[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Hong Kong[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD]Hong Kong[/TD]
[TD="align: right"]51[/TD]
[/TR]
[TR]
[TD]Hong Kong[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]Taiwan[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Taiwan[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD]Taiwan[/TD]
[TD="align: right"]51[/TD]
[/TR]
[TR]
[TD]Taiwan[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]Australia[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Australia[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD]Australia[/TD]
[TD="align: right"]51[/TD]
[/TR]
[TR]
[TD]Australia[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]Korea[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Korea[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]Korea[/TD]
[TD="align: right"]48[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD="align: right"]48[/TD]
[/TR]
[TR]
[TD]Japan[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Japan[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]Japan[/TD]
[TD="align: right"]48[/TD]
[/TR]
[TR]
[TD]Iceland[/TD]
[TD="align: right"]142[/TD]
[/TR]
[TR]
[TD]Iceland[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]Iceland[/TD]
[TD="align: right"]77[/TD]
[/TR]
[TR]
[TD]Iceland[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]Iceland[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]England[/TD]
[TD="align: right"]142[/TD]
[/TR]
[TR]
[TD]England[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]England[/TD]
[TD="align: right"]77[/TD]
[/TR]
[TR]
[TD]England[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]England[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]Thailand[/TD]
[TD="align: right"]142[/TD]
[/TR]
[TR]
[TD]Thailand[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]Thailand[/TD]
[TD="align: right"]77[/TD]
[/TR]
[TR]
[TD]Thailand[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]Thailand[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]Norway[/TD]
[TD="align: right"]142[/TD]
[/TR]
[TR]
[TD]Norway[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]Norway[/TD]
[TD="align: right"]77[/TD]
[/TR]
[TR]
[TD]Norway[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]Norway[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]India[/TD]
[TD="align: right"]142[/TD]
[/TR]
[TR]
[TD]India[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]India[/TD]
[TD="align: right"]77[/TD]
[/TR]
[TR]
[TD]India[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]India[/TD]
[TD="align: right"]64[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]

Hope someone can help me.


Thanks in advance for the helps

 

[jarjarbingie]

Hi,　

I have difference info from Sheet1 & Sheet2 and I need to combine them into Sheet3.

[TABLE="width: 354"]
<tbody>[TR]
[TD]sheet1[/TD]
[TD][/TD]
[TD][/TD]
[TD]sheet2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Item[/TD]
[TD]Reading[/TD]
[TD][/TD]
[TD]Item[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]China[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]70[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]Hong Kong[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]51[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]Taiwan[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]45[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]Australia[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD]B[/TD]
[TD]Korea[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD]B[/TD]
[TD]USA[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]48[/TD]
[TD][/TD]
[TD]B[/TD]
[TD]Japan[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]142[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]Iceland[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]21[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]England[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]77[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]Thailand[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]Norway[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]64[/TD]
[TD][/TD]
[TD]C[/TD]
[TD]India[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 157"]
<tbody>[TR]
[TD]sheet3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Reading[/TD]
[/TR]
[TR]
[TD]China[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]China[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD]China[/TD]
[TD="align: right"]51[/TD]
[/TR]
[TR]
[TD]China[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]Hong Kong[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Hong Kong[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD]Hong Kong[/TD]
[TD="align: right"]51[/TD]
[/TR]
[TR]
[TD]Hong Kong[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]Taiwan[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Taiwan[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD]Taiwan[/TD]
[TD="align: right"]51[/TD]
[/TR]
[TR]
[TD]Taiwan[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]Australia[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Australia[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD]Australia[/TD]
[TD="align: right"]51[/TD]
[/TR]
[TR]
[TD]Australia[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]Korea[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Korea[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]Korea[/TD]
[TD="align: right"]48[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD="align: right"]48[/TD]
[/TR]
[TR]
[TD]Japan[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Japan[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]Japan[/TD]
[TD="align: right"]48[/TD]
[/TR]
[TR]
[TD]Iceland[/TD]
[TD="align: right"]142[/TD]
[/TR]
[TR]
[TD]Iceland[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]Iceland[/TD]
[TD="align: right"]77[/TD]
[/TR]
[TR]
[TD]Iceland[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]Iceland[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]England[/TD]
[TD="align: right"]142[/TD]
[/TR]
[TR]
[TD]England[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]England[/TD]
[TD="align: right"]77[/TD]
[/TR]
[TR]
[TD]England[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]England[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]Thailand[/TD]
[TD="align: right"]142[/TD]
[/TR]
[TR]
[TD]Thailand[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]Thailand[/TD]
[TD="align: right"]77[/TD]
[/TR]
[TR]
[TD]Thailand[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]Thailand[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]Norway[/TD]
[TD="align: right"]142[/TD]
[/TR]
[TR]
[TD]Norway[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]Norway[/TD]
[TD="align: right"]77[/TD]
[/TR]
[TR]
[TD]Norway[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]Norway[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD]India[/TD]
[TD="align: right"]142[/TD]
[/TR]
[TR]
[TD]India[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]India[/TD]
[TD="align: right"]77[/TD]
[/TR]
[TR]
[TD]India[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]India[/TD]
[TD="align: right"]64[/TD]
[/TR]
</tbody>[/TABLE]

Hope someone can help me.


Thanks in advance for the helps

2017-08-22_9gszrtjk | Files.fm.