I tried switching both to text and both to number formats, but it's still not
giving me a result. The green arrows are still there for only some the
accounts.

This is the vlookup formula I'm using. Do you know if there is anything
that I could add to the formula to pick up other accounts?

=VLOOKUP(accounts!A2,desc!$A$1:$B$318,2,FALSE)

"John Bundy" wrote:

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.