In the attached spreadsheet, I seek to find duplicate ID numbers between Column A (List 1) and Column D (List 2). You will notice that the values of E3 and F3 (both have bad data) does not equal the values of B4 and C4, though they are associated with the same ID. In column G (Matched), a formula drops in the duplicated ID numbers.
In this example, I want H4 and I4 to contain the (bad) data from E3 and F3, but only because the data is mismatched. If it all matched correctly, I would want the matched name and address to remain blank, like what you see with the matched ID 5 in G7.
What formula is required in H4 and I4?