Provide output of Multiple criteria match

Hi,
I used the formula " =NOT(ISERROR(MATCH(B4;D4;0)))" to test the match between just two variables.
Now, I would need to get a statement by using multiple match horizontal critera.
I was lost while testing HLOOKUP nests:

1) variable "up/down" in Column B (B4) must match with variable "up/down" in Column D (D4);
2) if the result of (1) is FALSE, then print "FALSE" in Column E;
3) if the result of (1) is TRUE, then match with variable "up/down" in Column C (C4)
4) if C4 is the opposite of B4 and D4, then print "TRUE" in Column E4
5) if C4 = B4 = D4, then print "FALSE" in E4

Thank you very much for any suggestion

PS: I now attach the file. sorry & Tx!

-------------
Ideal output;;;;;
Reference LIST;Condition A;Condition B;Condition C;A = C * B
ENSG0000013;down;down;down;FALSE
ENSG00000083;up;up;--;FALSE
ENSG00000147;down;down;down;FALSE
ENSG000001076;up;--;--;FALSE
ENSG0000014;down;--;down;MAYBE
ENSG0000011711;down;down;down;FALSE
ENSG000001840;down;up;down;TRUE
ENSG0000018298;up;up;up;FALSE
;;;;;;;;
Good output;;;;
Reference LIST;Condition A;Condition B;Condition C;A = C * B
ENSG0000013;down;down;down;FALSE
ENSG00000083;up;up;--;FALSE
ENSG00000147;down;down;down;FALSE
ENSG000001076;up;--;--;FALSE
ENSG0000014;down;--;down;TRUE
ENSG0000011711;down;down;down;FALSE
ENSG000001840;down;up;down;TRUE
ENSG0000018298;up;up;up;FALSE

mromano,

This is an excel forum, therefore, please post sample workbooks in Excel (.xls or .xlsx or .xlsm) formats.

That is more useful so that potential helpers can test their solutions properly on your workbook and provide more accurate solutions.

Hello mromano,

The following formula will produce the tristate results you are looking for in your "Ideal" table output.

=IF(AND(B4=D4,D4<>C4),IF(C4="--","MAYBE",TRUE),FALSE)