Values won't display after altering a formula.
 

I am using a Vlookup function that displays the value in the formula drop
down boxes but only displays the formula in the cell when completed.

The cell was probably formatted as Text *before* you entered the formula
itself.

Try this on a "bad" formula cell,

Select the cell, then:

<Ctrl <Shift <~,
Then<F2,
Then<Enter.

What you did here was,
Keyboard shortcut to re-format the cell to General,
Then re-entered the formula.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mike O" <Mike wrote in message
...
I am using a Vlookup function that displays the value in the formula drop
down boxes but only displays the formula in the cell when completed.