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.