you can do this in multiple ways. you can achieve using LINQ, if you are not much familiar with LINQ. you can achieve it using below steps
- Read both sheets and keep in 2 data tables
- loop for all values in sheet 1
- in loop use lookup data table activity provide service number of sheet 1 and check in sheet 2 is available or not.
- Based on the response you can delete in sheet 1 dt or create a new data table(dt) to capture the required data
Happy Automation!!!