Search formula missing words

[Manolocs]

Hello I am using =IF(COUNTIF($A:$A, $F4)=0,"TRUE","NOT TRUE") to find same words.
The problem is I need to find any word in the cell that is equal to the one in F4.
Something like this: column A: car / cars Column F4 cars so the search is NOT TRUE. I need the formula to find any word that match the at least one in column A. Any help is more than welcome.

 

[Caribeiro77]

if i really understand what you need...

=IF(COUNTIF($A:$A,"*"&$F4&"*")=0,"TRUE","NOT TRUE")

 

[Manolocs]

@Caribeiro77 It is working, help me a lot, Thank you Caribeiro