Niek Otten wrote:
Why not introduce a third column which combines A and B and then use a
simple (and fast!) lookup with the combined A and B from the other sheet?
Sorry if I misunderstood your question

Do not be sorry, I've been stuppid to say i need a match while i really
need the no matches. I tryed and thought about your (i'am sure verry
fast) solution. but i can't see how find the no matches with a third
colom because there are also many values in sheet one that have no match
in sheet two but where i'am not intressted in and combining can create
new values witch can cause unwanted matches


Maybe an example clears it up what i'am looking for

sheet one sheet two
colom colom colom colom
A B A B
45 45 110 2100
110 2102 110 2102
120 2102 120 2104
120 2104 120 2106
130 2106 130 2108
130 2106 130 2110
130 2108
130 2110
140 2110

In this example i need the number of row 3 and the number of the last
row of sheet one,

Because 2102 in sheet two is assigened to 110 , however colom A in sheet
one says 120 coppled to 2102,
and the last row of sheet one because, 2110 is assigened 140 , but in
sheet two 2110 is coppled to 130.

Hope someone can make sence of this