Pulling Correct Number of Dates Based on Column Value

[SamP89]

I have a sample set of data below and need help constructing a formula for it. In the formula column below, I have the result that I am expecting from the formula I need. For this formula, I need it to check ID2 and see what the value is in the Number column. Based on this, I then need it to check the ID1 and Date column and bring back a match for the correct number of dates.

So, because 123456 has a value of 2, I need it to get a match for the first two dates only. 234567 has a value of 1, so I only need to get a match for the first date. Any ideas on how to write this?

Formula	Date	ID1	ID2	Number
Match	12/7/2017	123456	123456	2
Match	1/7/2018	123456	234567	1
N/A	6/7/2018	123456
N/A	7/7/2018	123456
Match	10/7/2017	234567
N/A	11/7/2017	234567
N/A	1/7/2019	234567
N/A	2/7/2019	234567

 

[dreid1011]

Here is this to start, but it would be more helpful if you updated your profile to show what version of Excel you are using:

Book1
	A	B	C	D	E
1	Formula	Date	ID1	ID2	Number
2	MATCH	12/7/2017	123456	123456	2
3	MATCH	1/7/2018	123456	234567	1
4	N/A	6/7/2018	123456
5	N/A	7/7/2018	123456
6	MATCH	10/7/2017	234567
7	N/A	11/7/2017	234567
8	N/A	1/7/2019	234567
9	N/A	2/7/2019	234567
Sheet1

Cell Formulas
Range	Formula
A2:A9	A2	=IF(COUNTIF($C$2:C2,C2)<=VLOOKUP(C2,$D$2:$E$9,2),"MATCH","N/A")