Forum

Found the formula through another forum: =ARRAYFORMULA(IFERROR(LOOKUP(2,1/SEARCH(" "&C4&" "," "&A$4:A$7&" "),A$4:A$7),"")) Chee...

The best I could do was this one and that's based on 'partial match' =unique(if(isblank(A4:A7),"",(IFERROR(VLOOKUP("*"&C4&"*",$A$4:$A7,1,FA...