How to get IF & LOOKUP to only tag exact matches?

[bwe89]

Hi everyone, I don't come here often but the community has been very supportive when I have a question - thanks for that!

I am using this formula to tag certain cells based on their contents =IF(LOOKUP(2^15,SEARCH({"will"},C18)),"Yes")

The problem is that the formula is tagging cells where a word comprises of these words in it. So, for example, it is tagging 'William' and "Wills" instead of the only the word 'will' which is what I want.

Do you know if there is any way to add an exact match to this formula?

 

[pgc01]

Hi

Is "will" is always surrounded be spaces or alone?
If that's the case include the spaces in the search.

 

[bwe89]

Hi

Is "will" is always surrounded be spaces or alone?
If that's the case include the spaces in the search.

pgc01 this worked perfect -thanks

 

[pgc01]

I'm glad it helped.