Either of two...............

1. You have set your sheet to "View Formulas" hit CTRL `(backquote) to togle
off/on.

2. The cell was pre-formatted as text and Excel thinks the formula is text.
Format to General then F2 and ENTER


Gord Dibben MS Excel MVP

On Fri, 4 Apr 2008 15:01:01 -0700, jasmine
wrote:

Have any of you had the following trouble:

I type in the vlookup formula and rather than giving me an answer, it
displays the formula i typed out. When i open the formula wizard it shows
that it is finding the correct value, but not displaying it. I have checked
cell formats and everything else.

Any ideas?