Unable to match data in different excel sheet

Help
, , ,
1

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)

2

Hi @Aathira_Ajayan

May be there are leading and trailing spaces in excel cell values

Are you using trim function on string values while comparing?

3

Hi @Karun
I tried that also. But it is not working.

4

Did you check the condition?