Using "IF" statement when cell contains key words

Hi guys

Is is possible to do an "IF" statement to return a value if another cell contains a specific word i.e.

Lets say A1 contains the sentence "I want to go shopping.

Could an IF statement be written in B1 that recognises that A1 has the word "shopping" in it and returns a value based on that?

Cheers

Mac

Hi there

That works perfectly thank you. Just out of interest is it possible to add a further condition i.e.

Using my previous example if A1 contains the word "shopping" and A2 is greater than 10 return a value

I tried =IF(AND(ISNUMBER(SEARCH("shopping",A1),A2>10),"Yes","No")) however, it tells me I have too many arguments.

Cheers

Mac

Again perfect. Thanks for your help on this. It's really appreciated :-)