Formula not working

  • Thread starter Thread starter Freeman, Cathy
  • Start date Start date
F

Freeman, Cathy

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
 
Might be...

Tools > Options > Calculations > Check Automatic.OK

HTH
Regards,
Howard
 
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
 
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!
 
Your original proble was that the cells were formatted as
Text..........hence the formulas showing.

Your trip through Data>Text to Columns changed the formatting to General and
in essence, re-entered the formulas.


Gord Dibben MS Excel MVP
 
Back
Top