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]

I would suggest that you make the first column of your result table by copying the first column of items from each list into one column so you have one list of all the variables, then you can perform a Remove Duplicates from the Data menu... you can then sort, if necessary,

Then you can do a Vlookup to each original table to find the matches, if any.

So if original table 1 is in A:C and your second table is in F:H and your "non-duplicate" list is in column K, then in K2, enter =IFERROR(VLOOKUP(K2,$A$2:$B$11,2,0),"--") and copy down, and in L2

=IFERROR(VLOOKUP(K2,$F$2:$H$11,2,0),"--")

you may need to replace the commas with semicolons and translate the functions to Italian.