Hi,

I am using a formula to find matches of words:

=IF(OR(COUNTIF(R7,"*"&$AI$2:$AI$8&"*")), "Yes", "")

However, it is finding "too much".

E.g. I want it to find "oil", but I don't want to see where the word "boiler" has been used.

Can I only find exact matches (bearing in mind sometimes it will be oil. oil, .Oil etc as it is human input with different grammar).

Cheers,
Hurg