combined COUNTIF ?

Hi,
I am working with Excel 2011 (Mac). I have two lists of records ("genes") and each has an associated variable ("up" or "down").
I know how to find duplicates (by using COUNT IF), but I would like to know if it is possible to retrive (and compare) the associated variable for each duplicated record.
I have attached the two lists and the possible output
Thank you very much in any case!

LIST 1;;;
;A;B;C
1;Gene ID;Regulation SI;Fold-Change SI
2;ACC;up;1.61
3;BCC;down;1.26
4;CCC;down;1.66
5;DCC;up;2.66
6;ECC;down;3.66
7;FCC;up;4.66
8;GCC;up;5.66
9;HCC;up;6.66
10;JCC;down;7.66
11;ICC;up;8.66

LIST 2;;;
;A;B;C
1;Gene ID;Regulation SI;Fold-Change SI
2;ACC;down;4.66
3;DCC;down;2.66
4;ECC;down;3.66
5;EGC;down;1.66
6;FCC;up;4.66
7;ICC;up;8.66
8;KCC;down;7.66
9;LCC;down;7.66
10;MCC;up;6.66
11;XCC;down;1.26

Comparison;A;B;C
1;LIST 1;LIST 1;LIST 2
2;ACC;up;down
3;BCC;down;--
4;CCC;down;--
5;DCC;up;down
6;ECC;down;down
7;FCC;up;up
8;GCC;up;--
9;HCC;up;--
10;JCC;down;--
11;ICC;up;up
12;KCC;--;down
13;LCC;--;down


Example.pdf[/FONT]