Hi,

Try this in cell C2 of sheet A

=if(countif(sheet2!M2:M100,B2)=1,"Found","Not found")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Lisa" wrote in message
...
This is probably easy, but I'm having a heck of a time figuring out the
formula.

I have two spreadsheets with similar data. I am trying to figure out if
the
data in a cell (B2) on spreadsheet A (a value like "A452") exists at all
anywhere within a column (M) on spreadsheet B (where the cells read like
"A002, A452, A223"). Since the data can be anywhere in the cell, and
anywhere in the column, I can't seem to find a formula to work.

Help! Thanks!