I have two excels, e-maillist(one excel) and weeklydata(one excel), if Dept column matches, send e-mail to relevant address

I Have two excels (mailList, weeklyData_01sep_05sep).
Excel : weeklyData_01sep_05sep:
if column “Dept Code” and “Dept Code_C”, matches then send Header and Matched row to e-mail address defined in mailList(excel).
for Ex: if “AB-00017” matched in both columns(“Dept Code” and “Dept Code_C”),
send “AB-00017” row include headers to steven.c@gmail.com stella.k@gmail.com

Please refer to attached excel, please helpmailList.xlsx (12.4 KB)
weeklyData_01sep_05sep.xlsx (8.4 KB)

Hi @Sudhir_P ,

You could load these two sheets into DataTables.
Then do an Inner Join with the DataTable Join activity
From the resulting join you will get only the matching rows
Once you have that you can pick up the data and email and use it send the emails