PDA

View Full Version : Formulas that do not run



rcbricker
04-19-2007, 05:50 AM
I have had this problem before and I am wondering if there is a fix.

I type a formula (usually a vlookup) such as:

=VLOOKUP(D19,$D$19:$E$29,2,0)

And instead of it returning any value it appears exactly as typed, like this:

=VLOOKUP(D19,$D$19:$E$29,2,0)

I can not get the formula to run and I do not know why this happens.

Any one know what the problem is?

Thanks

Minstrel
04-19-2007, 05:56 AM
Is it possible that in Tools>Options>View, the Formulas checkbox is ticked?

xld
04-19-2007, 05:57 AM
The cell is probably formatted as text.

Select the cell, and do Find/Replace (ctrl-H), using values of = and = (yes, the same), and OK it.

rcbricker
04-19-2007, 09:18 AM
Yes the formula box was checked under the view tab.

XLD if I run into the problem again and the formula box is not checked I will try your solution.

xld
04-19-2007, 09:40 AM
No that is a difefrent thing, that means that the view was to show formulae not results. I was referring to where a particular cell is formatted as text.