Home

Formula appearing in cell instead of the result

Geoff2017
Occasional Visitor

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

1 Reply

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies