| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP formula results strange after copying down
Yes Charles, I'd just discovered that. Sorry for being such a Numpty.
|
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| GET.CHART.ITEM returning strange results | Charts and Charting in Excel | |||
| Copying formula results into cells with numerical formats | Excel Discussion (Misc queries) | |||
| Database Functions - Strange results | Excel Worksheet Functions | |||
| Strange Occurrence Copying Formula | Excel Discussion (Misc queries) | |||
| Strange Results with Autofilter | Excel Discussion (Misc queries) | |||
Linear Mode
