software

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,
Davequot;Lindaquot; wrote:

gt; While using VLOOKUP, the result is not showing up...only the formula. But
gt; while I was actually entering the formula in VLOOKUP the value was showing
gt; 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: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=494598Thanks David,
Unfortunately, this did not work.

quot;David Billigmeierquot; wrote:

gt; Try hitting Ctrl ` (the key directly to the left of the 1). You may have the
gt; option to display all formulas enabled.
gt;
gt;
gt; --
gt; Regards,
gt; Dave
gt;
gt;
gt; quot;Lindaquot; wrote:
gt;
gt; gt; While using VLOOKUP, the result is not showing up...only the formula. But
gt; gt; while I was actually entering the formula in VLOOKUP the value was showing
gt; gt; up. But once I hit OK only the formula showed up. Please help!!!

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

quot;Lindaquot; wrote:

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

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

quot;SteveGquot; wrote:

gt;
gt; Or the cell you are entering the formula in was formatted as text prior
gt; to entering it. Delete the formulas, re-format to General and re-enter
gt; your formulas. Then you can re-format back to text if need be.
gt;
gt;
gt; Cheers,
gt;
gt; Steve
gt;
gt;
gt; --
gt; SteveG
gt; ------------------------------------------------------------------------
gt; SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
gt; View this thread: www.excelforum.com/showthread...hreadid=494598
gt;
gt;

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

quot;Lindaquot; wrote:

gt; While using VLOOKUP, the result is not showing up...only the formula. But
gt; while I was actually entering the formula in VLOOKUP the value was showing
gt; 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-gt;Options-gt;'Calculation' tab-gt;Check 'Automatic' to turn automatic
calculation on.
2) Do you have an equals sign (=) in front of your formula?--
Regards,
Davequot;Lindaquot; wrote:

gt; Thanks David, but this did not help. Any other suggestions?
gt;
gt; quot;Lindaquot; wrote:
gt;
gt; gt; While using VLOOKUP, the result is not showing up...only the formula. But
gt; gt; while I was actually entering the formula in VLOOKUP the value was showing
gt; gt; 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,
Davequot;Lindaquot; wrote:

gt; I just realized that all areas that contain formulas are showing the formula
gt; and not the result. Can anyone help?
gt;
gt; quot;Lindaquot; wrote:
gt;
gt; gt; While using VLOOKUP, the result is not showing up...only the formula. But
gt; gt; while I was actually entering the formula in VLOOKUP the value was showing
gt; gt; 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 gt; Clear gt; All, and re-enter the
formula.
You might also post back the exact formula you are using.
--
Ken Hudsonquot;Lindaquot; wrote:

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