If you want it a tad cleaner, and to show a blank in C when A is blank, use this:
=IF(IFERROR(MATCH(IFERROR(CONCATENATE(TEXT(LEFT(A11,FIND(",",A11)-1),""),", ",TEXT(LEFT(MID(A11,FIND(" ",A11)+1,256),1),"")),""),INDIRECT(CONCATENATE("$E$2:",ADDRESS(COUNTA($E:$E),5))),0),0)<>0,"On Roster",IF(A11="","","Not On Roster"))
|