Looking for a formula to help with a Roster

Occasional Visitor

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

1 Reply

@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?

certain text and name.JPG