-
Formulas that do not run
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
-
Is it possible that in Tools>Options>View, the Formulas checkbox is ticked?
-
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.
-
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.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules