Hi @jan.alemany
Use the two read range workbook activity to read the two sheets in the excel.
In first read range workbook give the sheet name of first sheet name, store it to dt1 and in second read range workbook give the sheet name of second sheet, store it to dt2.
Use for each row in datatable activity to iterate the dt1 inside this activity use another for each row in datatable activity to iterate the dt2.
Inside second for each take If activity in that activity write the condition which column have to be compare. In your case give like this
Currentrow1(Column3 name).equals(Currentrow2(“Column1 name”)).
In then block take an assign activity to store the value in the Column 2 in second sheet.
- Assign → ValueVariable = Currentrow2(“Column2 name”).
Use the write cell workbook activity to write the valuevariable in the Currentrow1(“Column4 name”)
Hope it helps!!