Match keywords from two different columns

[Chirag_Gandhi07]

Hi Everyone,

I have a spreadsheet with two columns. I would like to compare the two columns to know which share the same key words. For example:

Office 1                                                        Org

LLTP1-San Diego ABC SO CA                   ABC San Diego Sales Office

LLTP2-Davidson ABC SO NC                     ABC Davidson Sales Office

How can I determine the rows that have matching keyword(s) between the two columns?

Any help would be greatly appreciated!

Thank you

[fmvizcaino]

Hi @Chirag_Gandhi07 ,

I've tried to use fuzzy match but I wasn't able to see great results, so I've created another (not so great) way of checking the keywords.

LEt me know if that makes sense to you.

Best,

Fernando Vizcaino

[Chirag_Gandhi07]

Hi @fmvizcaino This is really helpful. Thank you so much! Is it possible to also add a column that displays the matched words?

[fmvizcaino · Accepted solution]

Sure @Chirag_Gandhi07 ,

I added that in the attached workflow.

Best,

Fernando Vizcaino

[Chirag_Gandhi07]

Thanks @fmvizcaino!