Forum Discussion

mhasanali381's avatar
mhasanali381
Copper Contributor
Jun 03, 2021

Partial String Match Based on Range and Return Matched Word

I'm Trying to Extract the Name from the Description if it matches our Customer Names List. Please see attached image    Here is What I want to do.   If Column B contains any word(Partial String M...
excel
HansVogelaar's avatar
HansVogelaar
MVP
Jun 03, 2021

mhasanali381 

In G2 as an array formula confirmed with Ctrl+Shift+Enter:

 

=IF([@Desc]="","",TEXTJOIN(", ",TRUE,IF(ISNUMBER(SEARCH(" "&TableName[[Column1]:[Column2]]&" "," "&[@Desc]&" ")),TableName[[Column1]:[Column2]],"")))

 

where TableName is the name of the table.

  • mhasanali381's avatar
    mhasanali381
    Copper Contributor
    Jun 04, 2021

    Thanks @HansVogelaar, 

    Your formula is working. However, it is returning the same string Many Times. Check attached Screenshot

     

    Is there a way to keep only unique words?

     

     

     

     

Resources