Find list of words from sheet2 in sheet1 before a comma and extract text vba

[satish78]

Hi Friends,

Trying to find the solution on my task. But did not find suitable one to the need.
Here is my query and sample file with details.

Need a formula to find list of words before a (,) comma from sheet2A:A in Sheet1A:A(there is no data range like A1:a10) and extract text before the match
Formula should out put results like shown in ColumnD
ColumnC has found words from sheet2A:A in sheet1A:A

Hightail Spaces

Hightail Spaces lets you send unlimited files, of any size, to anyone. Collaborate with your team and evolve your work.

spaces.hightail.com

 

[satish78]

I am unsure as I did not understand the rest of the post.

Could we have a bit more of simple sample data and expected results set out in two worksheets and in a form that we can copy from to test?

Peter here is sample file with results.
Data in Sheet1A:A
VBA1 keywords in Sheet2A:A
VBA2 keywords in Sheet3A:A

Hightail Spaces

Hightail Spaces lets you send unlimited files, of any size, to anyone. Collaborate with your team and evolve your work.

spaces.hightail.com

 

[Peter_SSs]

Not sure that I can help with that.