Easy formula to return a true or false

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!

Hi!

Try this:

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

Biff

"motol" <[email protected]> wrote in message
news:[email protected]...
>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!
>