VLOOKUP formula results strange after copying down
 

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?

VLOOKUP formula results strange after copying down
 

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" wrote in message
...
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?

VLOOKUP formula results strange after copying down
 

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

VLOOKUP formula results strange after copying down
 

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

VLOOKUP formula results strange after copying down
 

Sounds like you have manual calculation, ToolsOptionsCalculation. Check
the setting.

--
---
HTH

Bob


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



"Code Numpty" wrote in message
...
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?

VLOOKUP formula results strange after copying down
 

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

Any other ideas?

"Charles Williams" wrote:

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" wrote in message
...
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?

VLOOKUP formula results strange after copying down
 

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

On Jul 31, 12:10*am, CaptSpify
wrote:
I've got the same issue, except that my automatic Calculation IS turned on.