Three Column Comparsion Against Another Three Columns

[Excell1677]

Hello Wizards of Excel,

I currently trying to compare three lists vs another three lists to see if they match or not. My goal here is to mark 'Match" if all three columns from list 1 matched all three columns from list 2 and if any of the of the columns doesn't match against list one it would either not match or return the value of the column that doesn't match (either option would work). I tried using a1=b2 and Index Match but it didn't give me the results I wanted. I also tried using VBA to see if this worked but it didn't work either. I provided a sample file of the problem with this post.

Any help with this would be appreciated

Thank You for your time

[Bo_Ry]

Maybe try at I4

=IF(AND(E4=A4,F4=B4,G4=C4),"Match",IF(A4=E4,"",E$3&" ")&IF(B4=F4,"",F$3&" ")&IF(C4=G4,"",G$3&" "))

[Ghozi Alkatiri]

at G4 array formula CSE

=IF(A4:C4=E4:G4=TRUE,"Y","N")

or non array formula
=IF(SUMPRODUCT((A4:C4=E4:G4)*1)=COLUMNS(A:C)=TRUE,"Y","N")

[Ghozi Alkatiri]

sorry formula at I4

[Excell1677]

Thanks Ghozi and Bo_Ry,

Both of these solutions worked exceptionally well Thanks!