Is there a way in VBA to compare two sets of numbers to see if there is a match, and use each value only once? For example (imagine each number is in its own cell and there are 3 columns):

1 2 3 matches with 1 2 3
1 3 3 does not match with 1 2 3
1 2 3 matches with 1 3 2


I'm looping through worksheets in a workbook and comparing them to a column in a different workbook. I can probably handle the specifics, but need a little help with the technique.

Thanks,