Simple "if word exist among theese cells, then true"

[JemyM]

Im banging my head on the "find" functions. They give me a -value- when
I need TRUE/FALSE for an IF function.
It must be a much easier way to return TRUE or FALSE if a word exist
within an area:

Data:
A1: Orange
A2: Apple
A3: Banana

Function:
1: Is "*Apple*" in A1:A3? = TRUE!
2: Is "*Tomato*" in A1:A3? = FALSE!

 

[Niek Otten]

=NOT(ISNA(VLOOKUP(B1,A1:A3,1,FALSE)))

 

[Bob Phillips]

=COUNTIF(A1:A3,"*Apple*")>0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[JemyM]

=COUNTIF(A1:A3,"*Apple*")>0

=NOT(ISNA(VLOOKUP(B1,A1:A3,1,FALSE)))

Fantastic! Thanks guys