I'm trying to identify matches between column D & K, AND THEN, out of those matches, which ones have matches on column A & H. Basically columns D (ABC) & A (123) are linked, and K (ABC) and H (123) are linked. So out of matches between D (ABC) & K (ABC), which of those also have matches between A(123) & H(123). I know columns D & K have many matching values, but I only care about out of those matches, which ones also have matches in their corresponding columns A & H.
So I want a list of match results as following (the end result): 1. D & K, THEN 2. A & H
So there could be 3,546 matches on #1, but out of those matches, only 450 that share both #1 AND #2. It's like an IF/THEN scenario. I think in excel its the vlookup option but I can't get it to work. I also think an Access query could work comparing sheet 1 to sheet 2 and pulling a sheet 3 that shows matches between sheet1 column A and sheet2 column A AND sheet 1 column B and sheet 2 column B.