I have 2 excel sheets , where one of them has one(dt1) column and the other has 2(dt2). I want to check if the value in dt1 matches the value in dt2 ( in the 2nd column) then get the value from it’s corresponding column ( which is (the 1st column).
Here what I have so far:
I have read both the excel file using read range and stored it to a variable data table
I used for reach loop to get the each row from dt1 and then used if else statement to check if the value exist in dt2( column 2). I got stuck here, how do I specify the robot to look at dt1 value in dt2 data table and which expression do I use to get the corresponding value(column 1 of dt2) if dt1 value is found in dt2(2nd column).