That's a lot of possible combinations so a long running macro will b
needed.
You could try to generate all the combinations in each by using th
binary representation of the two to the power or the number of items i
the column as a key to show which items to try together.
If you then loop through the combinations between the two columns, yo
can list the matches as they occur somewhere else on the sheet