Hey. can anoyone help me?

I have column A cells filled with text. I need to find out which cells in column A contain a particular word (would be better if i could look up a phrase) in their text.
I need column B to indicate that.

For example, if A1 has a text "my wife is beautiful. i love her" and i want to know if it has the word "love" in it [formula in B1 has to result in 1 if A1 has the word "love", if it doesnt, the result should be 2 (#N/A is also ok)].

its urgent for my thesis and the formulas i found on the web are not working for some reason.

Here's a pic of the actual sheet. i have 370 cells like that in column A. i need to look up for phrases that might be in the middle of the text.

help.JPG

Thank you!!