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?
Bookmarks