Dear I have three columns in one sheet and three columns in another sheet ; want to compare both columns and if all three entries are matching gives me the fourth column (date )as result
sheeti sheet2
1 2 3 4 1 2 3
13332545669 14432545669 625691 12-Dec-15 13332545669 14432545669 625691
13332545670 14432545670 525691 13-Dec-15 13332545670 14432545670 525691
13332545671 14432545671 452146 14-Dec-15 13332545671 14432545671 452146
13332545672 14432545672 586233 15-Dec-15 13332545672 14432545672 586233
13332545673 14432545673 265465 16-Dec-15 13332545673 14432545673 265465
13332545674 14432545674 516112 17-Dec-15 13332545674 14432545674 516112
13332545675 14432545675 215135 18-Dec-15 13332545675 14432545675 215135
13332545676 14432545676 114162 19-Dec-15 13332545676 14432545676 114162
13332545677 14432545677 114166 20-Dec-15 13332545677 14432545677 114166
13332545678 14432545678 548465 21-Dec-15 13332545678 14432545678 548465
13332545679 14432545679 165165 22-Dec-15 13332545679 14432545679 165165
13332545680 14432545680 566513 23-Dec-15 13332545680 14432545680 566513
13332545681 14432545681 321155 24-Dec-15 13332545681 14432545681 321155
13332545682 14432545682 235161 25-Dec-15 13332545682 14432545682 235161
13332545683 14432545683 154154 26-Dec-15 13332545683 14432545683 154154
13332545684 14432545684 165165 27-Dec-15 13332545684 14432545684 165165
13332545685 14432545685 212122 28-Dec-15 13332545685 14432545685 212122
13332545686 14432545686 184815 29-Dec-15 13332545686 14432545686 184815
13332545687 14432545687 101154 30-Dec-15 13332545687 14432545687 101154
13332545688 14432545688 203215 31-Dec-15 13332545688 14432545688 203215
13332545689 14432545689 203202 1-Jan-16 13332545689 14432545689 203202
13332545690 14432545690 651616 2-Jan-16 13332545690 14432545690 651616
13332545691 14432545691 201112 3-Jan-16 13332545691 14432545691 201112
13332545692 14432545692 231413 4-Jan-16 13332545692 14432545692 231413
Bookmarks