Yes, Sure.
I will execute this bot once or twice in a month.
SO, first I will check column “Decision” IF any blanks are there .
For that blank rows EX: P2 is blank then I have to pick the value of C2 and search on website.
Need to match the records from Excel to website.
IF match : Update P2 Completed
If not match : Update P2 Not Match
I am able to got it upto this.
Now the Query is :
EX: C2 = 120 , C3=120, C4
: P2= Completed, P3 = “”, P4=“”
When Bot do the above process and try to update P3, it is again updating P2 because It is taking first occurance of the duplicate rows.
I am using Lookup range here, And when multiple same rows on column C then it is just taking first all the time.
Let me know if you still have doubt on the question.
Thank You