Hi guys, I have a scenario.
I have to read values from excel 1 column D and find that value in excel 2, column A3. if the value is not found , write error excel 1, column E.
I tried doing this but it wries error in every row of column e in excel 2. Do you guys have any idea. attaching dummexcel1.xlsx (8.1 KB)
y excel sheetsExcel2.xlsx (11.1 KB)