Check data cross file(excel)

Help Activities
, ,
1

Hello,
I have 3 file (input , master , report)

I want to check condition as below.

  1. Check Dup
    1.1 Check dup column SR# in file input or not —> If dup stamp Y in column N
    1.2 Check dup with file report if match column SR and column Activity #–> check column Closed Date file report have text or not
    1.2.1 If text = “working” or blank ----> stamp N in column N
    1.2.2 If text <> “working” but have value ----> stamp N in column N
    1.3 Check dup with file report if match column SR → check column Closed Date file report have text or not
    1.3.1 If text = “working” or blank ----> stamp Y in column N
    1.3.2 If text <> “working” but have value ----> stamp N in column N

  2. Check file input column (SR Category,SR Sub Category,SR Issue,SR Product Line)
    2.1 Check column SR Category,SR Sub Category,SR Issue,SR Product Line from file input with file master if match stamp Y in column O , else stamp N

  3. Check_Div
    3.1 Check column SR Category,SR Sub Category,SR Issue,SR Product Line with file master If match check column Div in file master that have text CC or not
    If have text CC stamp Y in column N , else stamp Y

Please guide me for solve it.
Thank you.

input1.xlsx (10.4 KB)
Report.xlsx (492.1 KB)
Master.xlsx (12.9 KB)

2

Can anyone guide me to solve it?

Thank you