How to Compare Values in 2 columns vs another 2 columns which produces an action item

Good Afternoon Excel forum

Sorry to bother you, but i am trying to build some use cases and i have hit a mental blocks.

Aim -in column (a - c) we have a an id 1234. as this id is populated in column (a -c) if any value in column e & f. differ then i need to produce a column to provide the reason.

Unfortunately i dont know the format which i will be provided (as trying to predict in row (8-10), however one thing i can be assured of is that column (A & D) will always match with the same ID.

i have attached an sample file, i am happy with the outcomes in row 3-6 and i am just wondering is there any additional scenarios i am missing ?

i have manually looped through to populate my helper column (j), is there a formula which helps me get to the same answer ?

Looking forward to the communities help

Regards
d

Please try at J3 and drag down

=IF(A3="","",IF(E3&F3="","NO ACTION HIEARCHY CORRECT",IF(B3<>E3,"UNLINK FROM IP","UNLINK FROM UP")))

Hi All,
Thanks for your feedback.
@ Bo_Ry - comparing the expected outcome against your formula, it looks like its not handling row 6 correctly.

The Reason why Row 6 is "Unlink from UP" Is because the value 3333 (Col F) is not the same as value as 1234 (COl A-C).

@ Jose - comparing the expected outcome against your formula, it looks like its not handling row 4/5 & 10 correctly.
The Reason why Row 4 is "Unlink from IP" Is because the value 2222 (Col E) is not the same as 1234.(COl A-C).
The Reason why Row 5 is "Unlink from IP" Is because the value 2222 (Col E) is not the same as 1234.(COl A-C).
The Reason why Row 10 is "Unlink from IP" Is because the value 2222 (Col E) is not the same as 1234.(COl B).



I have added a screen shot to show difference.

Many thanks

Please try again,

=IF(A3="","",IF(E3&F3="","NO ACTION HIEARCHY CORRECT",IF((B3<>E3)*(E3<>""),"UNLINK FROM IP","UNLINK FROM UP")))