Hi, welcome to the forum
Unless there is more to your formula that you have mentions, then Im not sure why you would need to use INDIRECT() here...
.=INDIRECT("Costs!A1")
If you are simply referencing cell A1 on sheet Cost, then you could simplify that to...
=cost!A1
Or, rather...
=IF(cost!A1="","",cost!A1)
Bookmarks