APP1.xlsx (8.7 KB)
test1.xlsx (8.7 KB)
I attached two excel sheet Test1 and App1.
Select the “Sr.no” one by one in “Sr.no” column in Test1 and check that Sr.no is available in App1
If Sr.no not available in App1, put comment as SR not found in “Comment” column in Test1 for that Sr.no
If Sr.no is available in App1, Check the “Status” column in App1
If status column value is “Not Open” in App1, put comment as SR Mismatch in “Comment” column in Test1
If status column value is “Open” in App1, Check the “Type” column in App1
If Type column value is “Not LI” in App1, put comment as SR type Mismatch in “Comment” column in Test1 for that Sr.no
If Type column value is “LI” in App1, go to next Sr.no in Test1