Try:

=IF(ISERROR(INDEX('Overall Details'!$A$2:$A$51,SMALL(IF('Overall Details'!$B$2:$B$51='Team 1'!$B$2:$E$2,ROW('Overall Details'!$A$2:$A$51)-1,""),ROWS('Overall Details'!$A$2:A2)))),"",INDEX('Overall Details'!$A$2:$A$51,SMALL(IF('Overall Details'!$B$2:$B$51='Team 1'!$B$2:$E$2,ROW('Overall Details'!$A$2:$A$51)-1,""),ROWS('Overall Details'!$A$2:A2))))&""


That's just added &"" to the end. Confirmed with Ctrl-Shitf-Enter.


Regards