While using VLOOKUP, the result is not showing up...only the formula. But
while I was actually entering the formula in VLOOKUP the value was showing
up. But once I hit OK only the formula showed up. Please help!!!

Try hitting Ctrl+` (the key directly to the left of the 1). You may have the
option to display all formulas enabled.


--
Regards,
Dave


"Linda" wrote:

While using VLOOKUP, the result is not showing up...only the formula. But
while I was actually entering the formula in VLOOKUP the value was showing
up. But once I hit OK only the formula showed up. Please help!!!

Or the cell you are entering the formula in was formatted as text prior
to entering it. Delete the formulas, re-format to General and re-enter
your formulas. Then you can re-format back to text if need be.


Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=494598

Thanks David,
Unfortunately, this did not work.

"David Billigmeier" wrote:

Try hitting Ctrl+` (the key directly to the left of the 1). You may have the
option to display all formulas enabled.


--
Regards,
Dave


"Linda" wrote:

While using VLOOKUP, the result is not showing up...only the formula. But
while I was actually entering the formula in VLOOKUP the value was showing
up. But once I hit OK only the formula showed up. Please help!!!

Thanks David, but this did not help. Any other suggestions?

"Linda" wrote:

While using VLOOKUP, the result is not showing up...only the formula. But
while I was actually entering the formula in VLOOKUP the value was showing
up. But once I hit OK only the formula showed up. Please help!!!

Thanks SteveG, but this did not help either. Any other suggestions?

"SteveG" wrote:


Or the cell you are entering the formula in was formatted as text prior
to entering it. Delete the formulas, re-format to General and re-enter
your formulas. Then you can re-format back to text if need be.


Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=494598

I just realized that all areas that contain formulas are showing the formula
and not the result. Can anyone help?

"Linda" wrote:

While using VLOOKUP, the result is not showing up...only the formula. But
while I was actually entering the formula in VLOOKUP the value was showing
up. But once I hit OK only the formula showed up. Please help!!!

Try 2 other options:

1) Hit F9. If this option works, you have automatic calculation turned off.
Tools-Options-'Calculation' tab-Check 'Automatic' to turn automatic
calculation on.
2) Do you have an equals sign (=) in front of your formula?


--
Regards,
Dave


"Linda" wrote:

Thanks David, but this did not help. Any other suggestions?

"Linda" wrote:

While using VLOOKUP, the result is not showing up...only the formula. But
while I was actually entering the formula in VLOOKUP the value was showing
up. But once I hit OK only the formula showed up. Please help!!!

Linda -
I am more convinced your problem is due to my first post. Are you sure you
did it correctly? With your sheet open, push Ctrl + ` (grave accent). This
is the key to the left of the 1 on your keyboard, and directly below the esc
button.

--
Regards,
Dave


"Linda" wrote:

I just realized that all areas that contain formulas are showing the formula
and not the result. Can anyone help?

"Linda" wrote:

While using VLOOKUP, the result is not showing up...only the formula. But
while I was actually entering the formula in VLOOKUP the value was showing
up. But once I hit OK only the formula showed up. Please help!!!

Hi Linda,
This may be redundant but it is worth a try.
Highlight the entire column, go to Edit Clear All, and re-enter the
formula.
You might also post back the exact formula you are using.
--
Ken Hudson


"Linda" wrote:

While using VLOOKUP, the result is not showing up...only the formula. But
while I was actually entering the formula in VLOOKUP the value was showing
up. But once I hit OK only the formula showed up. Please help!!!

I had the same problem and this last suggestion by Ken worked for me.

Thanks, Ken.


--
GX624
------------------------------------------------------------------------
GX624's Profile: http://www.excelforum.com/member.php...o&userid=29801
View this thread: http://www.excelforum.com/showthread...hreadid=494598