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't use other formulas either.
Anyone know the source of this issue?
5 Replies
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?
- Have you tried using the xlookup function instead?
