| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula not working
Lately, when I enter formula for a vertical lookup, it will only show me the
formula instead of the results. What am I doing wrong? example formula entered: =VLOOKUP(A2,'ICD9 Codes'!A:C,3,0) only reflects: =VLOOKUP(A2,'ICD9 Codes'!A:C,3,0) rather than results |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula not working
Might be...
Tools Options Calculations Check Automatic.OK HTH Regards, Howard "Freeman, Cathy" <Freeman, wrote in message ... Lately, when I enter formula for a vertical lookup, it will only show me the formula instead of the results. What am I doing wrong? example formula entered: =VLOOKUP(A2,'ICD9 Codes'!A:C,3,0) only reflects: =VLOOKUP(A2,'ICD9 Codes'!A:C,3,0) rather than results |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula not working
You might also have the cell formatted as text. Change the format to
general. You'll probably also have to force the cell to re-evaluate (click on it and hit return should do it). Will "L. Howard Kittle" wrote: Might be... Tools Options Calculations Check Automatic.OK HTH Regards, Howard "Freeman, Cathy" <Freeman, wrote in message ... Lately, when I enter formula for a vertical lookup, it will only show me the formula instead of the results. What am I doing wrong? example formula entered: =VLOOKUP(A2,'ICD9 Codes'!A:C,3,0) only reflects: =VLOOKUP(A2,'ICD9 Codes'!A:C,3,0) rather than results |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula not working
Do you have the 2007 version? I couldn't figure out exactly where to go with
your directions. I have 2007. I selected Data Tools, then text to columns, I selected the delimited option and this corrected the issue. Thanks for pointing me in the right direction! "L. Howard Kittle" wrote: Might be... Tools Options Calculations Check Automatic.OK HTH Regards, Howard "Freeman, Cathy" <Freeman, wrote in message ... Lately, when I enter formula for a vertical lookup, it will only show me the formula instead of the results. What am I doing wrong? example formula entered: =VLOOKUP(A2,'ICD9 Codes'!A:C,3,0) only reflects: =VLOOKUP(A2,'ICD9 Codes'!A:C,3,0) rather than results |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula not working
Your original proble was that the cells were formatted as
Text..........hence the formulas showing. Your trip through DataText to Columns changed the formatting to General and in essence, re-entered the formulas. Gord Dibben MS Excel MVP On Wed, 23 Sep 2009 14:04:01 -0700, Freeman, Cathy wrote: Do you have the 2007 version? I couldn't figure out exactly where to go with your directions. I have 2007. I selected Data Tools, then text to columns, I selected the delimited option and this corrected the issue. Thanks for pointing me in the right direction! "L. Howard Kittle" wrote: Might be... Tools Options Calculations Check Automatic.OK HTH Regards, Howard "Freeman, Cathy" <Freeman, wrote in message ... Lately, when I enter formula for a vertical lookup, it will only show me the formula instead of the results. What am I doing wrong? example formula entered: =VLOOKUP(A2,'ICD9 Codes'!A:C,3,0) only reflects: =VLOOKUP(A2,'ICD9 Codes'!A:C,3,0) rather than results |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A formula not working as the result of a previous formula? | Excel Discussion (Misc queries) | |||
| Formula not working | New Users to Excel | |||
| Formula Not working | Excel Discussion (Misc queries) | |||
| formula not working right | Excel Worksheet Functions | |||
| formula not working | Excel Worksheet Functions | |||
Linear Mode
