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?