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]

Please help me with this.

 

[MARK858]

I doubt you will get many replies as the site you are using states

Note: This file was uploaded by an unregistered user of FileToLink.
To download the file, you have to authenticate via Facebook or Google+.

Try using a site like www.dropbox.com or www.box.com or better still (because some won't/can't download files at all) post some usable screenshots =, there are some links to some ways to do this in my signature block below.

 

[jaimond]

Here is the link: https://www.dropbox.com/s/e1wn3l8auqgpl32/vba requirement.xlsx?dl=0
Thank you for let me know that the link was not working.

 

[jaimond]

Sheet 2 contains key list.

 

[MARK858]

Assuming that the results are what you have in H, I and J why is God not either a complete or partial match in row 2?and why would "God" with the quotes ever match God without the Quotes?

For anyone who can't download who wants to have a stab at it...

Excel 2010
	A	B	C	D	E	F	G	H	I	J
1	Multi paragraph sentences	complete match	partial match	Partial mismatch	complete match	partial match	Partial mismatch	complete match	partial match	Partial mismatch
2	God is Great.	"God"
3	Goddess. Goddess. Goddess		"God"	Goddess		"God"	Goddess		"God"	Goddess
4
5	she is Moody. He is moody.		Mood	Moody		Mood	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		Jackson	1hiJacked
Sheet1

Excel 2010
	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	Jackson
Sheet2

 

[jaimond]

Actually I want to find if the given keys matched completely or not. If it matched completely it should go to complete match. If Not how is that differs from the original. so Partial mismatched and partial matched. Hope this makes sense.

"Not in row 2" because in First column data can be in any row. So I preferred row by row output in next columns.

 

[MARK858]

Why would Jackson be a complete match where the string being searched only has the word 1hiJacked which bares any resemblance? and the quotes are still a question.

 

[jaimond]

Jack is the common string between Jackson and 1hiJacked.

 

[MARK858]

Jack is the common string between Jackson and 1hiJacked.

I am afraid I can't think of a sensible way of writing anything for a part of any keyword to be searched for. Perhaps someone else can help you.