I have the below formula that takes two rows and matches 5 data points. at the point if all five match then I get an "OK". if they dont I get a #N/A. I was hoping to ultimately get something that will tell me whcih cells dont match without having to use 5 or 6 nested IF statements. If this can be done in VBA easier that would be great as well.
thanks!
=IF(AND(MATCH(C32,M32),MATCH(D32,N32),MATCH(E32,O32),MATCH(F32,P32),MATCH(G32,Q32)),"OK","Please Review")
thanks!
=IF(AND(MATCH(C32,M32),MATCH(D32,N32),MATCH(E32,O32),MATCH(F32,P32),MATCH(G32,Q32)),"OK","Please Review")