Rather than automation, i think you can concatenate the two columnsto get a unique column and get a vlookup to compare data.