I applied this function on D2, and it works but matching should be case sensitive. At this moment, it match anyting similar. Example, It repeats Intern for International or Internal. But it should not do this way. If Intern not found on Title (C), then should show nothing. Pls help. INDEX(REGEXEXTRACT(E2:E, TEXTJOIN("|", 1, C2:C)))

Here is image link:

CodePudding user response：

use:

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