Are you sure both are numbers? It sounds as if one is text and the other
number

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Vince" wrote in message
...
I am trying to compare SSN (social security number) from one file with SSN
from another file. When I use the vlookup command, I get N/A for a
result.
Both SSN files are formatted Special SSN so they should work.
When I copy one SSN to its mate on the second file, I get a valid result
for
that entry. This tells me that both SSN files are incompatible. Any
suggestions?