In C1, enter:
=IF(SUMPRODUCT(--ISNUM(FIND(B1:B3;$A$1)))0;TRUE;FALSE)

See example: http://cjoint.com/?eblmKt6Cpa

HTH
--
AP

"Prohock" a écrit dans le message de
...
I need a function that will use a column of text values and test these
values
to see if one or more of the values exist in a single cell. If it does I
need
the function to return true or false.

Ie. cell A1 contains the text "Jim Smith" the B column contains the test
names (column of test values ) ie. B1 is "bill" B2 is "fred" B3 is "jim".
Because Jim is in the cell A1 I would need the function in C1 to return
the
value "true". If A1 contained the text "bob smith" then function in C1
would
return the value "false".