VLOOKUP result is not showing up - only the formula

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

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.

SteveG's post (#3) works for me. Thank you!