My Bot should take first guy Sanjay’s Amount from Excel A and match it with the amount of Sanjay’s in Excel B and if there is any match, then return that entire row that contains “Name, Description, Amount” into the separate DataTable.
Note - The Bot should compare the two Excel with respect to Name only, If Bot Took Sanjay’s amount from excel A, it should verify with only Sanjay’s Data in Excel B to find a match and return the entire row
And for your info, Excel A and B can have many columns, But Name, Amount, Description are unique.
Thanks in Advance!!