Fine
Hope these steps would help you resolve this
—use excel application scope and pass the file path of first excel as input
—inside the scope use Read range activity and get the output with a variable of type datatable named dt1
—again use another excel application scope and pass the file path of second excel as input
—inside that use read range and get the output with a variable of type datatable named dt2
—now use a for each row loop and pass the above
Variable dt1 as input and change the variable name from row to row1
Inside this loop use another for each row loop and mention the input as dt2 and change the variable name from row to row2
Now use a IF condition like this inside the inner for each row loop
row1(0).ToString.Equals(row2(0).ToString)
If this condition passes it will go to THEN part where we can use assign activity like this
row2(1) = row1(1).ToString
And another two assign activity like this
row2(2) = row1(2).ToString
row2(3) = row1(3).ToString
We don’t need to use lookup for this case
Cheers @Priyanka_Sorate