VLOOKUP formula appears in the cell I need to see the result in
 

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?

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?

Many thanks JulieD - your first option was the case. I had thought of that
initially but only checked the column containing the number range I was
searching against and never thought to check the column where I wanted the
result to come in to.
Many thanks.
--
Cheers Sharon


"JulieD" wrote:

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?

You're welcome, and thanks for the feedback

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Shaynes" wrote in message
...
Many thanks JulieD - your first option was the case. I had thought of that
initially but only checked the column containing the number range I was
searching against and never thought to check the column where I wanted the
result to come in to.
Many thanks.
--
Cheers Sharon


"JulieD" wrote:

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?