1- Read file 1 with output dt1
2 Read file 2 with output dt2
3 iterate on dt1 with the help of foreachrow
4 In body check file with respect to item(“Report “)
5 if file exist then get value of item(No.).ToString.Split({”,”},StringSplitOption.Nonone) in array of string variable.
6 Iterate each value of array with the help of foreach activity.
7 Use filter activity and pass input as dt1 and output as filterdt and in condition column name as “No.” and in value item2 value of foreach loop
8 If filterdt have some count then update value to respective cell with the help of writecell activity.
Now you have question in your mind how I will find index of row where value need to be updated so for that use lookup activity.
Let me know if you face any issue.
Try this it will work.