Yes, you are correct.. I screwed up... I didn't have a sample to check against...I misplaced some parts of the Index function...

try this instead:

=IF(ROWS($A$1:$A1)>COUNTIF('Hot Zone Customers'!$C$2:$C$561,$C$4),"",INDEX('Hot Zone Customers'!$C$2:$T$561,SMALL(IF('Hot Zone Customers'!$C$2:$C$561=$C$4,ROW('Hot Zone Customers'!$C$2:$C$561)-ROW('Hot Zone Customers'!$C$2)+1),ROWS($A$1:$A1)),14))