=OR(ISNUMBER(SEARCH("4",B2:B10)))

entered with ctrl + shift & enter


--

Regards,

Peo Sjoblom


"steve" wrote in message
...
The search function only lets you look in one cell.

Why can't you use: search(4,B2:B10)

is there something that can just tell me if there is a 4 in that range? I
dont want to use vlookup, i just need to know if it is true or false