Easy formula to return a true or false

motol · Jul 4, 2006

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!

Biff · Jul 4, 2006

Hi!

Try this:

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

Biff