Matching multiple number rows and check corresponding dates within 90 days

Essentially what i need to do is see if there is a matching number from A2, in column D. Then check is the corresponding date from A2 which is in B2, is within 90 days of the corresponding date from colum E. Date in B must be >= than E and <91 days from E to count.

i.e. Number 24902 date 12/20/22 - is matched to 3 rows in D, but the date is before any of those in E so it doesnt count. Number 24902 date 3/11/23 is matched to 3 rows in D, and the date is within 90 days of row 3. Therefor it does count.

I've tried Vlook of course, but since it only checks for the first value on the list, it doesnt see any additional values that may match.

I'm thinking its probably an index match, with if(and( but i can't seem to get it to check multiple rows for a match to see if both D and E meet the criteria.

The formula in cell C9: (it's a CSE formula for older versions) and drag down.

=IF((OR((B9>=IF(A9=D$9:D$12,E$9:E$12,99999))*(B9<IF(A9=D$9:D$12,E$9:E$12,99999)+91))),"COUNT","NO")