Formula not showing result

Garmon D
Garmon D ✭✭✭
edited 12/09/19 in Smartsheet Basics

I have a sheet where users enter a cost, which is then picked up via x-sheet formulas on another sheet and matched against the relevant budget code. There's another column in the original sheet that then works out via VLOOKUP what the remaining budget is. However it doesn't always show the result - the formula is still there but the cell is blank. Any thoughts?