Jun 02 2019 10:02 PM
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
Jun 02 2019 10:22 PM - edited Jun 02 2019 10:24 PM
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.
Feb 10 2024 02:50 PM