I am trying to understand whether E column's any keywords available on C column people Title or not. But it is not working. Kindly help. This is my formula =ArrayFormula(INDEX(E$2:E$1000,MAX(IF(ISERROR(find(E$2:E$1000,C2)),-1,1)*(ROW(E$2:E$1000)-ROW(E$2) 1)))) [Image] https://docs.google.com/drawings/d/18yvkFNHDU0tBfCDgROQoROXuUIgGqdy9KUN1EHXhiLo/edit?usp=sharing

Thanks,

Sohel

this is output i'm expecting https://docs.google.com/drawings/d/1KlixfjTmSXXQAudvDiFsZiykcgtP4Kt4MqILrlzQO1Y/edit?usp=sharing

CodePudding user response：

try in D2:

=INDEX(REGEXEXTRACT(C2:C, TEXTJOIN("|", 1, E2:E)))