Match keywords from two different columns

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

Fuzzy Match

Accepted answers

I added that in the attached workflow.

Best,

Fernando Vizcaino

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

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