I can't get those values to fail.....Perhaps in one of the columns there are
leading or trailing spaces, where the other column does not have them.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"Adam" wrote in message
...
The formula Fails on those types of Numbers i posted above

M4758375
12-67-8
056-76-23
08-22-456

So what i mean is that these types of numbers are found in both columns,
but
the code still comes out as true. I have tested the code for very simple
inputs such as 1, and 2, and it works fine.

"Adam" wrote:

Ok, i need some help.

I have two columns of data. For one of the columns, i need to find out
if
its contained somewhere, anywhere in the other column. So how was going
to
do it was useing an ISNA, Match function and create a new column called
Missing?, and then drag the code down, if its not contained then it will
output True, if it is there, then it will output False. This usually
works
great. The only problem im having is that my column contents are kinda
wacky. Here are some examples

M4758375
12-67-8
056-76-23
08-22-456

So both columns have data like this. And for some reason, my ISNA code
isnt
working.

Any ideas?

Thanks,

-Adam