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

Hi Ian,

I think you could have your calculation set to manual.

Set it to automatic: menu Tools, Option, tab Calculation set the radio
button Automatic;


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy