Formula returned in vlookup function
 

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

Formula returned in vlookup function
 

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

"87vette" wrote:

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

Formula returned in vlookup function
 

It did help Ron. Thanks for the help.

"Ron@Buy" wrote:

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

"87vette" wrote:

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