problem with vlookup

[herbie]

Problem with vlookup. Instead of returning the result of the vlooku
formula the original vlookup statement is shown in the cell. Fo
example if the formula is =vlookup(A2, B4:C200, 3, FALSE) then the cel
displays =vlookup(A2, B4:C200, 3, FALSE).

If you use the insert function button on toolbar and fill in th
function arguments the correct value is shown in the formula result bu
as soon as you hit enter the original formula appears in the cell

 

[Kevin Stecyk]

herbie,

I think if you go Tools | Options | View and deselect formulas (in Window
Options) you should be okay. I think your settings are to show formulas?

Regards,
Kevin

 

[Arvi Laanemets]

Hi

Or even simpler - the cell(s) with formula(s) are formatted as text.


--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets

herbie,

I think if you go Tools | Options | View and deselect formulas (in Window
Options) you should be okay. I think your settings are to show formulas?

Regards,
Kevin

 

[Kevin Stecyk]

Arvi,

One of our two solutions should address the issue.

Thank you.

Regards,
Kevin

Hi

Or even simpler - the cell(s) with formula(s) are formatted as text.

 

[herbie]

Thanks guys, checked both of your suggestions and neither make
difference? Any other ideas

 

[herbie]

Guys,

We just tried checked the formulas box in Tools|Options|View and the
unchecked - that fixed it up! Cheers Herbie

 

[herbie]

Guys, Sorry but still having problem... checkign and unchecking afor
mentioned tick box for formulas only seems to temporarily fix th
issue!... have you heard of this problem before?? I work in technica
support area and it's not the first time this problem has arisen.
We've tried in Excel 97 and Excel XP