Searching for a string of text within a longer string of text within an entire column

Hello,

I just posted a very similar problem, but now require a different solution for this problem. I am searching for a string of text within a longer string of text. I am trying to return a "Found" if the text is found in any format anywhere in the column e.g. a "Found" would be returned for the word orange even if the other words were variations on it e.g. "orange,"; "three oranges"; "oranges&".

If the word is not found within the cell, it will return a "Not Found".

I have provided an example in the attached spreadsheet.

Any help much appreciated!

You need wildcards on the criteria value

=IF(COUNTIF(A:A,"*"&C2&"*"),"Found","Not Found")

Thanks guys. The wildcard solution worked.

Thanks to both of you for your assistance.

You're welcome.