Formula appearing in cell instead of the result

[Geoff2017]

I have a spreadsheet with many tabs and look ups between the tabs, some cells have the formula showing instead of the result for the look up?

Can anyone help

Geoff

[#2]

Hi Geoff

Try Ctrl + ` in the sheet/s that have the issue. You may be looking at the formula instead of the result on those sheet/s.

Cheers Damien

P.S. Also check to see that nothing is in front of the = in that cell as well. If something like '=IF(... then you'll see the formula text.

[#3]

I had the same issue and the problem was some cells were formatted as text. Changing whole sheet to general and F2-ing into the janky cells and hitting enter to recalc fixed it.