Thread: Provide output of Multiple criteria match (II)

Hi
I got lost ( ) while trying to modify the formula to compare different columns:

=IF(AND(A3=B3;NOT(A3<>C3);A3<>E3);IF(I3="--";"MAYBE";TRUE);FALSE)

I would need to get a statement by using multiple match horizontal criteria.


1) variable "up/down" in Column A must match with variable "up/down" in Column B;
2) if the result of (1) is FALSE, then print "No Match" in Column F;
3) if the result of (1) is TRUE, then match with variable "up/down" in Column C and D;
4) if (C and D) are the opposite of (A=B), then print "Best" in Column F
5) if C and/or D is "--" (and A = B), then print "Possible" in Column F
6) if (A <> B) = C or D, then print "No good" in F



Please, find attached the file with the example and criteria.
Thank you very much for any suggestion


Maurizio