I am filtering out bar codes from excel1(HM.30 - BEAUTY from 31.10.19 to 10.11.19 (DPH) 071019) and search whether it is present in the excel2(multi bc 121119). Then I will update in the main excel sheet. Even though the barcode present in Excel2, it is showing “not present”.CarrefourWorkflow.zip (150.7 KB)
May be there are leading and trailing spaces in excel cell values
Are you using trim function on string values while comparing?
I tried that also. But it is not working.
Did you check the condition?