Comparing Two excel to get a Particular value and send mail

I have two excel like Branch Master and Ageing Report. I need to compare both the files using the column name Branch code in both the excel, if the branch code in Branch Master excel is equal to branch code in Ageing Report, i need to get Branch name and email id from Branch Master excel and also i need to send the corresponding data from the Ageing Report to retrieved mail id from the Branch Master.


It’s better if you can share some sample files of the Input and expected output

At a high-level I can tell you that you can use the Lookup Datatable activity to get the particular value


New Microsoft Excel Worksheet.xlsx (12.3 KB)
I have attached some sample data.