Comparing rows in three sheets
 

Hi all,

I am new in excel and have a problem could not solve. Please enlighten me.

I would like to find entries in Sheet C with the following criteria.
-compare Sheet A with Sheet B where A.COL1=B.COL1 and get a set X with 2 columns
-compare X with Sheet C where X.COL2!=C.COL1

The expected resutls are 2 for the following data.

Sheet A
COL1
A
B
C
D

Sheet B
COL1 COL2
A 1
B 1
C 2
D 3
E 4

Sheet C
COL1
1
3

Pleaes show me an example or give me some hints.

Thanks in advance for any inputs and ideas.

Wing