Compare 2 String Columns

[ngct1112]

Hi All, I have 2 columns [C1]&[C2] in my table, they are similar but not exact the same.

I am trying to compare these 2 columns, (If >1 word is match then "match", otherwise "Not match")

eg:

C1	C2	Custom
there are 2 blue pen	blue pen	Match
3 500kg box	mud	Not Match
10 laptop bundled	bundled	Not Match

May I know is there any way to achieve.

Appreciated!

[amitchandak]

@ngct1112 , In case you need to compare by splitting words you need to use a list that you can use Text.ToList on one of the column  and then have a solution like the one mentioned in this blog

https://www.excelguru.ca/forums/showthread.php?7724-Search-(Text-Contain)-multiple-values