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
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.
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.