On Nov 8, 3:38 pm, "Michael D. Ober"
wrote:
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.

Hi,

i've just tried your formula with a smaller range and it worked fine.

With A2:A37 filled with numbers 1 thru 36 '=VLOOKUP(A15-6,A:A,1)'
worked fine... the only time it didnt work was if A15-6 was a negative
number in which case the #N/A error appeared

hth

David