Are you using FALSE or 0 as lookup type? If not, that can explain it,
otherwise post the formulas and a little bit more info on what you are
trying to do


--

Regards,

Peo Sjoblom

"OCONUS" wrote in message
...
Trying to match the first six characters of a text string to text
characters
in a data table. I'm trying to use the VLOOKUP Function, but I keep
getting
the contents of the second to last cell in my designated column. I'm
having
a problem both with truncating the text string, and also using text to
search
for things. Anyway to convert similar text characters to unique numbers?
Looking for any suggestions