Compare dates in 2 lists and check if falls in same month with criteria

[xetrivity]

DATE	NO	AMOUNT		DATE	NO	QTY	AMOUNT	CHECK IF MONTH IS MATCHING
03/01/2016	389	250		03-01-2016	398	3	750	YES
03/01/2016	389	250		03-01-2016	390	1	250	YES
03/01/2016	389	250		03-01-2016	574	2	3900	YES
03/01/2016	390	250		04/02/2016 <colgroup><col width="64"></colgroup><tbody> </tbody>	410	1	500	NO
03/01/2016	574	1950		04/02/2016 <colgroup><col width="64"></colgroup><tbody> </tbody>	575	2	3900	NO
03/01/2016	574	1950		05/01/2016 <colgroup><col width="64"></colgroup><tbody> </tbody>	460	1	250	YES
03/01/2016	410	500		05/01/2016 <colgroup><col width="64"></colgroup><tbody> </tbody>	391	4	1000	YES
03/01/2016	575	1950		05/01/2016 <colgroup><col width="64"></colgroup><tbody> </tbody>	392	1	250	YES
03/01/2016	575	1950
03/01/2016	640	250
03/01/2016	391	250
03/01/2016	391	250
03/01/2016	391	250
03/01/2016	391	250
03/01/2016	392	250

<tbody>
</tbody>

Need help on above condition. i want to check with comparing number first and if it matches check if they fall in same month and return a string where it says yes or no.

 

[DHayes]

Give this a try.

=IF(DATEDIF(A1,E1,"m")>0,"no","Yes")

 

[xetrivity]

Give this a try.

=IF(DATEDIF(A1,E1,"m")>0,"no","Yes")

It is working but you are checking only dates. we have to check the number column also because the table on the left will have other months also. it will not work then.

 

[DHayes]

Would some something like this work?

{=IFERROR(IF(INDEX($A$3:$B$17,MATCH(1,($B$3:$B$17=F3)*($A$3:$A$17=E3),0),1)=E3,"Yes","No"),"No")}

Use SHIFT+CTL+ENTER

 

[xetrivity]

it works great. You are a genius.
although this checks the dates exactly not month. but worked around with helping columns.
Thank you.

 

[DHayes]

Hi,
Here is the one to check if it is in the same month.

=IF(AND(SUMPRODUCT(--(MONTH(E2)=MONTH($A$2:$A$16))),INDEX($B$2:$B$16,MATCH(F2,$B$2:$B$16),0),1),"Yes","No")