Match the key

[Anonymous]

Hello Experts.

Am struck at point where key word from A column should be match with the B column..Its not row by ro match..I have key word column with 100 rows and B column with Million rows  and need to check each key word from A column to entire B column where ever finds should flag as match else no match.

Attached a screenshot for reference.

Thanking you in advacce

[Anil_Babu_Samineni]

You image not uploaded properly, But by sentense given by you. I can assume this way will help

If(Index(Field1, 'Word')=Index(Field2, 'Word'), 'Match', 'Not Match')

[Anonymous]

Hello Anil

I tested the set expression works fine only row to row comparision But am looking for each key from A column to check in entire B column...please suggest

[Anil_Babu_Samineni]

please create sample application and outcome from that