=ISNUMBER(MATCH(A2,B:B,0))

will return TRUE or FALSE

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Anita" wrote in message
...
Hi

I've got 2 columns of data and want to find out if a value in col A exists
anywhere in column B - I thought the match function might do this but I
can't
work it out.

Thanks

Anita