Forum Discussion
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.
1 Reply
=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?
