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
--

Kind Regards,

Niek Otten

Microsoft MVP - Excel


"nom de plume" wrote in message
...
hello

i have a sheet (one) with about 4000 rows of values, in colom A there are
35 possible values and in colom B 700 possible values. combinations can
appear multiple times

In a second sheet i have colom B with the same 700 values as in colom B of
sheet one, and in colom A for each of these 700 values one of the 35
possible values. The 700 values are unique in this sheet.


Now i need to examen these 4000 rows and compare each value in colom B
with the same value in the second sheet colom B, if these match i need to
check if the values in the A coloms are the same.

I have this running with brute force FOR NEXT loops, but it take about 20
minutes to complete.

Does anybody have an idea how to speed it up.