Snasui Excel Forum

Hello experts
I am trying to get the formula in column N marked yellow to get the result. I have manually entered the expected result in column N. Can someone help me out with the formula to get the correct result Please ?

Tks

In cell K2 enter this formula,

=SUBSTITUTE(SUBSTITUTE(IF(COUNTIFS($C$2:$C$35,$C2,$B$2:$B$35,"<>"&$B2,$E$2:$E$35,$E2)=0,"Invoice No. Mismatch","")&IF(COUNTIFS($C$2:$C$35,$C2,$B$2:$B$35,"<>"&$B2,$F$2:$F$35,$F2)=0,"Date Mismatch","")&IF(COUNTIFS($C$2:$C$35,$C2,$B$2:$B$35,"<>"&$B2,$E$2:$E$35,$E2,$F$2:$F$35,$F2)>0,"Matched",""),"chDate","ch & Date"),"Mismatch &","&")

Enter and copy down.

Thank you, always awesome