Hi all

I'm new to the board so forgive me if I mess up.

I have a very basic INDIRECT function that is pulling data from a different page within the same workbook.

=INDIRECT("Costs!A1")
As you can see its referencing cell A1 of the Costs page.

The problem I'm having is if Cell A1 is blank (no data typed into it) then the function is return a 0 in the cell that the function is typed in.

I need it to keep the cell blank if no data exists in cell A1 of the Costs page.

I have been bashing my head on the screen all evening and cannot seem to understand how to make this work (can't see the wood for the tree's) so I'm hoping some of you kind people may be able to tell me where I am going wrong.

Thanks in advance

Bel