Comparing data between two Excel file

[RPA_Dev13]

Hi Everyone,

I have the below scenario please and any suggestion for it:
-1- dt1 data table for Excel 1, Columns: (“Code”)+ (“Description”)
-2-dt2 data table for Excel 2, Columns: (“Code”)+ (“Description”)

after true matching the codes for each row I need to match the description like find any word that could be matched between them for example:

code1= code2
des1(hi, for. fire)
des2(for. no,yes)

if there are any same words in both columns I have to write true and false if not, please how can I match it because sometimes comes like many words and numbers?

[irahmat (Indra Rahmat)]

Hi,

hope this way could solve your problem.

I use the excel formula to find the match word between where. what I will do is
I will provide the excel file that have 3 sheet where sheet 1 for the data of source file 1, sheet 2 for file 2 and sheet formula

good luck.

[SorenB]

Hello

Please take a look at the attached example below.

Compare data.xaml (16.6 KB)

Best regards,
Soren

[RPA_Dev13]

It is working perfectly now. I just forgot to add ‘for each’ for the word to match it. Good spot, lads. Thanks.