Forgive me, let me explain the logic a bit more and the addition I want to the code
The main input is J2 with secondary inputs K2:N2 and the output is O2
The only thing wrong with the above code is that IF J2=Not found, it is not outputting not found
Below is what I wanted to replicate to work with IF J2=Transfer
What this code says is just if I2 is not equal to GC, then follow this if statement:
If J2=discard, then if both K2:N2 say Agree, output Discard. If one of K2 or N2 say disagree then output conflict
If I2=GC, then follow this if statement:
If J2=discard, then all four of K2:N2: say agree, output Discard. If one of K2 through N2 say disagree then output conflict.
I wanted to just add on this block of code to the main formula(so it works with IFJ2=Transfer)
Bookmarks