Is the column "really" formatted as numbers?...... From the sound of things,
it's probably still formatted as TEXT, even tho it appears to be formatted as
numbers......sometimes it's really hard to get the formatting
converted......and especially if the column is imported from outside, it
could be reformatting itself as TEXT each time it's refreshed........maybe
you could just reformat your vlookup cell as TEXT.

Vaya con Dios,
Chuck, CABGx3




"guy12345" wrote:

Hello. For last 2 days I've been encountering a problem I have never seen
before. When I'm writing a function, for example a Vlookup. I get a N/A error
from one of the function arguements as it relates to the column I'm
refrencing. The column is formatted as a number however when I re-enter the
number the error goes away. This would be fine except I work with a lot of
records and it is very time consuming to keep re-entering all the numbers in
the column when their already there. Does anyone know what might be causing
this or how to fix it. I would really appricate any help you could give.
Thanks in advance.
-Ian