VBA: Match Sheet2 with worksheet1 and give the output as given in worksheet1.

[jaimond]

Match Sheet2 with worksheet1 and give the output as given in worksheet1.
Download excel file: 00566099ab_e/vba_requirement.xlsx : File Sharing - Upload and Send big Files : FileToLink

 

[jaimond]

If we ignore row 21...

 

[jaimond]

Can anybody help me with this please ? ignore row no 21.

 

[jaimond]

Help requested from experts.

 

[jaimond]

Re-edited my need,

Excel 2007

	A
1	Multi paragraph sentences
2	God is Great.
3	Goddess. Goddess. Goddess
4
5	she is Moody. He is moody.
6
7	mood….great mood. God is great.
8
9
10	All the glitters is not gold.
11
12
13
14
15
16	Jackson is Great. God bless him.
17
18
19
20
21	The plane was 1hiJacked. Police have caught the Hijackers.

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Excel 2007

	A
1	Word/Phrase/sentence/paragraph/numbers
2	God
3	Mood
4	All the glitters is not gold
5
6
7
8
9
10
11
12
13
14	Hijack

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

Excel 2007

	A	B	C	D	E	F	G
1	Multi paragraph sentences	complete match	Partial mismatch	complete match	Partial mismatch	complete match	Partial mismatch
2	God is Great.	God
3	Goddess. Goddess. Goddess		Goddess		Goddess		Goddess
4
5	she is Moody. He is moody.		Moody		moody
6
7	mood….great mood. God is great.	mood		mood		God
8
9
10	All the glitters is not gold.	All the glitters is not gold
11
12
13
14
15
16	Jackson is Great. God bless him.	Jackson		God
17
18
19
20
21	The plane was 1hiJacked. Police have caught the Hijackers.		1hiJacked		Hijackers

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

 

[jaimond]

Help please.

 

[jaimond]

Need simplified. Please find the file here https://www.dropbox.com/s/wj2kyp4upixn3eu/vba requirement.xlsx?dl=0