Hi

it is possible that the cell has been formatted to text prior to the entry
of the formula:
click on the cell, choose format / cells - number tab and click on general
and click ok.
then you might need to press F2 then F9 and enter to get it to work

or

tools / options / view tab, untick formulas

or

ensure that your VLOOKUP formula has no space before the =VLOOKUP(........

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Shaynes" wrote in message
...
I am using the VLOOKUP function but when I complete the formula, the
formula
just appears in the cell I need the result to show up in. Can anyone help?