Hi
Hope these steps would help you resolve this
—use a excel application scope and pass the file path first excel as input
—use a read range activity and get the output with a variable of type datatable named dt1
—use another excel application scope and pass the second file path as input
—use a read range activity and get the output with a variable of type datatable named dt2
—NOTE: if we have only excel but of different sheets then we can use two read range activity in a single excel application scope and name the second datatable variable named as dt2
—now use a for each row loop and pass the datatable variable dt1 as input
—inside the loop use a while loop and mention the condition like this Counter < dt2.Columns.Count
Where counter is int32 variable of default value 0 defined in the variable panel
—no inside the while loop use a if condition like this row(“yourcolumnname”).ToString.Contains(dt2.Columns(counter).Columnname.ToString)
—if this condition passes it will go to THEN part where we can include a assign activity to set a value to a cell we want (even with a write cell activity it’s possible)
Simple isn’t it
Hope this would help you
Kindly try this and let know for any queries or clarification
Cheers @Soundharya