How to return multiple results in a search

Hi jrlafrance- I have a solution that (currently) involves adding a helper column on the PT Scores sheet. This holds names in this format: "Smith, John".
Paste this ARRAY FORMULA in Status!A2, then press CTRL+SHIFT+ENTER to confirm. Now use the drag handle to fill down.

=IFERROR(INDEX(('PT Scores'!$D$2:$D$10000),MATCH(0,(COUNTIF(Status!$A$1:$A1,'PT Scores'!$D$2:$D$10000)+('PT Scores'!$C$2:$C$10000<>Status!$A$1)),0)),"")

NOTE: If after pasting, the formula appears as TEXT, a leading space got copied. Return to the formula bar and delete the space, then
press CTRL+SHIFT+ENTER again.

Please see the attached workbook. I will attempt to eliminate the helper column. Check back in 45 min. -Lee

Helper Column removed. See post # 5 for updated versions of workbook and formula.