Dan

That's great. How do I stop #value! if the result is false. I want to
leave the cell blank or say no/false

Thanks

Nev

"dan dungan" wrote:

Hi Nev

You may be able to use the search function.

=SEARCH(A2,B2)

Dan