M
Michael D. Ober
I have a large table where the column A is also the lookup column.
Basically, I'm doing a moving average over column A. In excel 2003, the
following works
=VLOOKUP(A264-3000,A:A,1)
In Excel 2007, I get #VALUE!. How can I use column A as the lookup source
and the result column?
For those of you interested, 3000 represents mileage (oil change
increments).
Thanks,
Mike Ober.
Basically, I'm doing a moving average over column A. In excel 2003, the
following works
=VLOOKUP(A264-3000,A:A,1)
In Excel 2007, I get #VALUE!. How can I use column A as the lookup source
and the result column?
For those of you interested, 3000 represents mileage (oil change
increments).
Thanks,
Mike Ober.