Hello all,

I use the formula below to load data from my 'Spil" sheet in my main sheet. Problem is that some cells have a 0 and some are blank (differs).
Is it possible to have both the 0 cells and blank cells as a dash or empty?

=IFERROR(INDEX(Spil!$1:$1048576;MATCH(C$1;Spil!$A:$A;0);MATCH($A3;Spil!$1:$1;0));"")

Before I copy the data with a macro I do some calculation on the mainsheet also, so I think it's necessary that it's not only is showing as empty or -, but the cells have to be empty also.

Would this be possible?