VLOOKUP formula results strange after copying down

[Code Numpty]

Excel 2003 - I have a VLOOKUP formula which I have copied down the column.
When I check the formula it has copied down correctly, yet the result
returned is that for the first cell in the column for every single one.

To get the correct result I have to double-click every single cell
containing the formula, which will then show the correct result.

This has only started happening recently. Has Excel corrupted in some way?

 

[Charles Williams]

Sounds like you are in Manual calculation mode:
Tools-->Options-->Calculation check Automatic

regards
Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

 

[Code Numpty]

I've run detect and repair and this is also happening with more simple
formulas. It's as if they are not actually calculating??

 

[Code Numpty]

Yes Charles, I'd just discovered that. Sorry for being such a Numpty.

 

[Bob Phillips]

Sounds like you have manual calculation, Tools>Options>Calculation. Check
the setting.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[CaptSpify]

I've got the same issue, except that my automatic Calculation IS turned on.
So weird!

Any other ideas?

 

[Pete_UK]

Post an example of your formula - you might have used absolute
addressing for the lookup value, so that you are always looking for
the first cell. Perhaps your table range is not quite what you think
it should be.

Hope this helps.

Pete