Using Index / Match. Values not showing up until all squares have values other than 0

[aedctalk]

Ok. In AW 147 i have a name being pulled

=IF(ISERROR(INDEX($F$7:$AS$7,MATCH(AX147,$F$42:$AS$42,0))),AX143,INDEX($F$7:$AS$7,MATCH(AX147,$F$42:$AS$42,0)))

In AX147 i have array pulling the value

={SMALL(IF(F42:AS42=0,0,F42:AS42),1)}

row 148 is similar put pulls small 2nd smallest

Now i have evening names and data using same methods as above in

row 149 1st smallest
row 150 2nd smallest


HERE"S THE ISSUE PART

I now want to pull the top 3 SMALLEST from my 4 rows into my chart table..

=IF(ISERR(SMALL(IF(AX147:AX150=0,"",AX147:AX150),1)),,SMALL(IF(AX147:AX150=0,"",AX147:AX150),1))

=IF(ISERR(SMALL(IF(AX147:AX150=0,"",AX147:AX150),1)),,SMALL(IF(AX147:AX150=0,"",AX147:AX150),2))

=IF(ISERR(SMALL(IF(AX147:AX150=0,"",AX147:AX150),1)),,SMALL(IF(AX147:AX150=0,"",AX147:AX150),3))

Now for some reason... none of my top 3 show up in my data chart until all 4 values for the formulas that were up at the top.. have something other than 0

How can i make my values for the 3 formulas directly above show up as soon as there is JUST ONE person that has both name and data visible?

Sorry hope that .. this makes sense :/