Looking for a formula to help with a Roster

[Malesh8788]

Need a formula that will reference a a cell range looking for an certain text and return the name within that row. 

[#2]

@Malesh8788 

=VLOOKUP("*"&$C11&"*",$D$2:$E$7,2,FALSE)

=INDEX($E$2:$E$7,MATCH("*"&$C11&"*",$D$2:$D$7,0))

Is this similar to what you are looking for?