i have been using these two formula; both are working correctly but need adjustment; if i use first formula all blank cells are shown as "0"; i have tried conditional formating, custom format to hide zeros but its not happening.
=IFERROR(INDEX($F10:$M10,MATCH(P$7,$F$7:O$7,0)),"0")

in second formula if result is shown blank my subsquent formula linked to the cell gave value error.
=IFERROR(INDEX($F10:$M10,MATCH(P$7,$F$7:O$7,0)),"")

this is my linked formula which got effected if cell is shown blank through formula
=IF(SUM(F10:AJ10)=0,"",IF(SUMPRODUCT(($F$6:$AJ$6=TRANSPOSE(Rtg!$C$2:$I$2))*($F10:$AJ10)*TRANSPOSE(OFFSET(Rtg!$C$3,MATCH($A10,Rtg!$A$3:$A$50,0)-1,0,1,7)))/30*$E10=0,"",SUMPRODUCT(($F$6:$AJ$6=TRANSPOSE(Rtg!$C$2:$I$2))*($F10:$AJ10)*TRANSPOSE(OFFSET(Rtg!$C$3,MATCH($A10,Rtg!$A$3:$A$50,0)-1,0,1,7)))/30*$E10))

need help please