Finding word, not a word within a word

[Hurg]

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

[bsalv]

without testing, just a guess and replace "." with " "

Please Login or Register  to view this content.

[bsalv]

Please Login or Register  to view this content.