Sounds like some may be stored as text and some as numbers, use the same for
all so you are comparing apples to apples.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Don" wrote:

I'm trying to do a vlookup on a list of accounts. The cells that have green
arrows in the top left corner give me no result. I think it has to do with
formating but I haven't been able to figure it out.