Good morning everyone,

Hopefully someone can help me out.

I'm tryin to go through each pair of cells for each row in column A and B, and see if they match another pair of cells elsewhere.

Here's an example worksheet.
example.xlsx

So I want a VBA code that basically does the following:

If Range("A1:B1") <<(appears in lookup table)>> then
I will loop this to repeat on every row.

So in the example, rows 7 to 10 would enter the IF statement, the rest would not.

If I concantenate A and B and the concantenate the table, I can just about do it with match, but I'd like to see if I can avoid adding more columns.

Any help that can be provided is appreciated.

VonRobbo