=IF(ISNA(MATCH(A1,B:B,0)),"Not found","Found")
--
David Biddulph

"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