Hi!

Try this:

=ISNUMBER(MATCH(A1,Sheet2!M1:M100,0))

Biff

"motol" wrote in message
oups.com...
I need to know if a specific cell in sheet1 can be found in sheet2
column M. I just want it to return a true or false.

Thanks!