Formula returned in vlookup function

  • Thread starter Thread starter 87vette
  • Start date Start date
8

87vette

I've used vlookup for a while now in the office 2003. Just converted to
office 2007. Now when I do a vlookup I get the formula displayed in my
current cell instead of a returned value. I can't figure our what I'm doing
wrong. Can someone help?
Thanks
bmc
 
You've probably got a tick in the wrong place:
Try Office Button (top left hand corner)
Excel Options (bottom line)
Click on advanced
Scroll down to Display options for this worksheet
and untick 'Show formulas in cells instead of their calculated results
Click OK
Hope this helps
 
It did help Ron. Thanks for the help.

Ron@Buy said:
You've probably got a tick in the wrong place:
Try Office Button (top left hand corner)
Excel Options (bottom line)
Click on advanced
Scroll down to Display options for this worksheet
and untick 'Show formulas in cells instead of their calculated results
Click OK
Hope this helps
Click to expand...
 
Back
Top