"T. Valko" wrote in message
...
"Harlan Grove" wrote in message
...
"T. Valko" wrote...
...
"T. Valko" wrote in message
...
Yes, I know FIND will match substrings BUT it will also match the full
cell content if the full cell content is only "os", "p", or "x".

What it boils down to is that I'm using the case sensitivity of FIND
versus the case sensitivity of EXACT.

Wrong.

ISNUMBER(FIND("ox","grossly inaccurate"))

returns TRUE, but EXACT("os","grossly inaccurate") returns FALSE.

The OP's formula, though case-insensitive, was full string matching.
Yours isn't. Yours could easily return false matches. Perhaps not for
"os" if the cells in question would only contain 1 or 2 chars, but if
they could contain 2 chars, then why couldn't they contain, say, "np" or
"xl" or "xp"? The false matches would be more likely against "p" or "x".
But I get it: you don't want to admit you screwed up on this one.

Search the archives for my name and the keyword disregard.

ISNUMBER(FIND("ox","grossly inaccurate")) returns TRUE

Hmmm....you sure about that?

http://img72.imageshack.us/img72/3725/findzm2.jpg

Ok, I see that your example was probably a typo and I get the point your
making...so I probably did screw up.

It won't be the last time, either, so be on the lookout!

--
Biff
Microsoft Excel MVP