Forum Discussion

Copper Contributor

Aug 13, 2022

Looking for a formula to help with a Roster

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

Gold Contributor

Aug 13, 2022

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