Formula or function displays after edit and not its result

[DaveR]

I'm using vlookup(). When first entered, the formula shows the proper result.
If I edit the formula in any way like simply retyping a part of it, the
result of the vlookup() is no longer displayed, only the cell formula is
displayed. Even if I change back to the original "working" entry. Here is a
specific example: =VLOOKUP($E$1,'F:\DocumentControl\Documents\DOC-001-D
(MODEL_NO)\[DOC-001-D (MODEL_NO).XLS]MODEL_NO'!$A$3:$AZ$1200,2)
Originally the "col_index_num" was a cell reference such as "M2" to a cell
containing a number "2". When the cell reference was changed to the actual
number "2", the spreadsheet failed and the function cell showed the function
itself and not the result of the function. Changing back to "M2" didn't fix
the problem. Any innocuous edit seemed to cause this problem.

 

[Pete_UK]

Your cell might be formatted as Text - format it as General, and then
double-click the cell as if to edit it then press <enter> to bring
about the change in format.

It might also be that your worksheet has been set to manual
calculation - Tools | Options | Calculation tab, and set to Automatic.

Hope this helps.

Pete

 

[DaveR]

Thank you very much. I was reading similar responses with same result. Simply
reformating the spreadsheet or specifically the cells in question, didn't fix
the problem. After a general "reformat" to General, In the formula bar I had
to copy the entry, clear the cell, then paste it back. That fixed it.

Thank you for your speedy response. ~Dave

Your cell might be formatted as Text - format it as General, and then
double-click the cell as if to edit it then press <enter> to bring
about the change in format.

It might also be that your worksheet has been set to manual
calculation - Tools | Options | Calculation tab, and set to Automatic.

Hope this helps.

Pete

I'm using vlookup(). When first entered, the formula shows the proper result.
If I edit the formula in any way like simply retyping a part of it, the
result of the vlookup() is no longer displayed, only the cell formula is
displayed. Even if I change back to the original "working" entry. Here is a
specific example: =VLOOKUP($E$1,'F:\DocumentControl\Documents\DOC-001-D
(MODEL_NO)\[DOC-001-D (MODEL_NO).XLS]MODEL_NO'!$A$3:$AZ$1200,2)
Originally the "col_index_num" was a cell reference such as "M2" to a cell
containing a number "2". When the cell reference was changed to the actual
number "2", the spreadsheet failed and the function cell showed the function
itself and not the result of the function. Changing back to "M2" didn't fix
the problem. Any innocuous edit seemed to cause this problem.

 

[Pete_UK]

You're welcome, Dave - glad you got it working.

Pete

Thank you very much. I was reading similar responses with same result. Simply
reformating the spreadsheet or specifically the cells in question, didn't fix
the problem. After a general "reformat" to General, In the formula bar I had
to copy the entry, clear the cell, then paste it back. That fixed it.

Thank you for your speedy response. ~Dave

Your cell might be formatted as Text - format it as General, and then
double-click the cell as if to edit it then press <enter> to bring
about the change in format.

It might also be that your worksheet has been set to manual
calculation - Tools | Options | Calculation tab, and set to Automatic.

Hope this helps.

Pete

I'm using vlookup(). When first entered, the formula shows the proper result.
If I edit the formula in any way like simply retyping a part of it, the
result of the vlookup() is no longer displayed, only the cell formula is
displayed. Even if I change back to the original "working" entry. Hereis a
specific example: =VLOOKUP($E$1,'F:\DocumentControl\Documents\DOC-001-D
(MODEL_NO)\[DOC-001-D (MODEL_NO).XLS]MODEL_NO'!$A$3:$AZ$1200,2)
Originally the "col_index_num" was a cell reference such as "M2" to a cell
containing a number "2". When the cell reference was changed to the actual
number "2", the spreadsheet failed and the function cell showed the function
itself and not the result of the function. Changing back to "M2" didn't fix
the problem. Any innocuous edit seemed to cause this problem.- Hide quoted text -

- Show quoted text -