VLOOKUP stuck on formula view

[szuri_partner]

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?

[#2]

Have you tried using the xlookup function instead?

[#3]

@Jagodragon 

Thank for your reply!

I tried it as you suggested, but i doesn't wotk either.

[#4]

@szuri_partner 

On the Formulas tab of the ribbon, click to un-highlight Show Formulas.

The keyboard shortcut is Ctrl+`

[#5]

It's not checked, I have other formulas that only shows the results

[#6]

@szuri_partner 

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?