Its sooo very close...there has to be someone here with the missing puzzle piece
How its supposed to work...
Compare each sheet1's column C to sheet2's column C.
If any data matches...compare each sheet's corresponding column D
If column D also matches...copy entire row of data to new sheet.
But what its doing...
If it matches column C's data, it will copy the entire row from sheet2 without comparing column D
Example:
sheet1
C | D
1 | 3
2 | 5
3 | 9
sheet2
C | D
1 | 4
2 | 3
3 | 9
output should only include 3 9
Bookmarks