Take a value from column D in excel 1 and find it in excel 2.if value DOES NOT EXISTS , write error IN EXCEL 2 IN COLUMN e

Help
1

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)

@balupad14

1 Like
2

@poojakumari Find below attached workflow.

new-------.xaml (13.0 KB)