=NOT(ISNA(MATCH("x",A1:A10,0)))
or
=NOT(ISNA(MATCH("-x",A1:A10,0)))
or
=NOT(ISNA(MATCH(B1,A1:A10,0))) where B1 contains the criteria to search

Bob Umlas
Excel MVP

"Remote Desktop Connection hotkey"
ft.com wrote in message
...
Hi!

I function that would search through column of text values (range with 1
column) and return TRUE if column contains value given as criteria or
FALSE
if there is no such value in given column

For example i have range A1:A10 and i want to find out whether this range
contains value x or - x