Hello guys,

I come to this forum in order to make a question related to excel and vba. The thing is that I have a column with approximatly 150 keywords (Column A), and another column with 500 sentences (Column B), what I would like to obtain in the column C, is the keyword from the column A which is within the sentece in the column B. I mean, checking for example de Keyword in A1, with all the sentences in column B, and if this word is included in a sentece, then writting that word in the column C. When I say "included", I want to say that the word must be excatly the same. Example:

A B C

green The green car green
blue The greenth house -
red The red trousers red
yellow He has a yellower wallet -


It would be really appreciate an answer as soon as possible

Thanks a lot and regards!