Forum Discussion
VLOOKUP stuck on formula view
I tried to use vlookup (as the picture shows below) but it stucked at the formula view. If I try to use autofill, it stays at the "I3" cell. It happens quite often, and after this issue appears i can...
On the Formulas tab of the ribbon, click to un-highlight Show Formulas.
The keyboard shortcut is Ctrl+`
It's not checked, I have other formulas that only shows the results
Make sure that the cells are not formatted as Text. After changing it to something else, select a cell, press F2 then Enter. Does that make a difference?