vlookup returns formula instead of value
 

When I enter vlookup formula, why does the formula appear in the cell as
opposed to the value that is returned?
for example, I entered in the cell =VLOOKUP(C2,stock,3,false); when I hit
enter, the cell still shows =VLOOKUP(C2,stock,3,false), when it should so the
looked up value of "S".

vlookup returns formula instead of value
 

Cell is probably formatted as Text. Right-click the cell then go to Format
Cells. Number Tab.
Set to General. Click OK. Press F2. Press Enter.

HTH,
Paul
--

"mmurph" wrote in message
...
When I enter vlookup formula, why does the formula appear in the cell as
opposed to the value that is returned?
for example, I entered in the cell =VLOOKUP(C2,stock,3,false); when I hit
enter, the cell still shows =VLOOKUP(C2,stock,3,false), when it should so
the
looked up value of "S".

vlookup returns formula instead of value
 

The cell was formatted to Text before the VLOOKUP formula was typed in.
Clear the cell. Then set the format to General. Then type the VLOOKUP
formula again.



Also make sure the display mode is not Equation....Toggle CNTRL-`
--
Gary''s Student - gsnu200777


"mmurph" wrote:

When I enter vlookup formula, why does the formula appear in the cell as
opposed to the value that is returned?
for example, I entered in the cell =VLOOKUP(C2,stock,3,false); when I hit
enter, the cell still shows =VLOOKUP(C2,stock,3,false), when it should so the
looked up value of "S".

vlookup returns formula instead of value
 

You're either looking at the FORMULA layer of Excel (toggle is ctrl/~) or the
cell is formatted as Text - try Format/Cells, change to General, then
re-enter the formula ({F2}/enter)

"mmurph" wrote:

When I enter vlookup formula, why does the formula appear in the cell as
opposed to the value that is returned?
for example, I entered in the cell =VLOOKUP(C2,stock,3,false); when I hit
enter, the cell still shows =VLOOKUP(C2,stock,3,false), when it should so the
looked up value of "S".

vlookup returns formula instead of value
 

I didn't realize that I needed to format the cell before entering the
formula...I just kept trying to format it with the formula already entered.
Thank you for your help...it worked.

"Gary''s Student" wrote:

The cell was formatted to Text before the VLOOKUP formula was typed in.
Clear the cell. Then set the format to General. Then type the VLOOKUP
formula again.



Also make sure the display mode is not Equation....Toggle CNTRL-`
--
Gary''s Student - gsnu200777


"mmurph" wrote:

When I enter vlookup formula, why does the formula appear in the cell as
opposed to the value that is returned?
for example, I entered in the cell =VLOOKUP(C2,stock,3,false); when I hit
enter, the cell still shows =VLOOKUP(C2,stock,3,false), when it should so the
looked up value of "S".

vlookup returns formula instead of value
 

Normally you don't need to format the cell as General before entering a formula.

Excel tries to help you if you have ToolsOptionsEditExtend Data Range Formats
and Formulas.

The cell gets formatted as Text due to formatting around it in other cells..


Gord Dibben MS Excel MVP

On Thu, 3 Apr 2008 13:44:01 -0700, mmurph
wrote:

I didn't realize that I needed to format the cell before entering the
formula...I just kept trying to format it with the formula already entered.
Thank you for your help...it worked.

"Gary''s Student" wrote:

The cell was formatted to Text before the VLOOKUP formula was typed in.
Clear the cell. Then set the format to General. Then type the VLOOKUP
formula again.



Also make sure the display mode is not Equation....Toggle CNTRL-`
--
Gary''s Student - gsnu200777


"mmurph" wrote:

When I enter vlookup formula, why does the formula appear in the cell as
opposed to the value that is returned?
for example, I entered in the cell =VLOOKUP(C2,stock,3,false); when I hit
enter, the cell still shows =VLOOKUP(C2,stock,3,false), when it should so the
looked up value of "S".