if, index, small - formula issue

hello

here is my formula

{=IFERROR(INDEX(INDIRECT("Master!"&F$6&":"&F$6),SMALL(IF(((INDEX(_Data,0,1))='Missed Accounts'!$D$9)*((INDEX(_Data,0,9))=" - ")*((INDEX(_Data,0,5))=RIGHT($D$11,LEN($D$11)-SEARCH(" ",$D$11))),ROW((INDEX(_Data,0,9))),""),ROW()-14)),"")}

it essentially filters by "billing cycle", employee name and shows me the data.

the issue is, in cell D11 (missed account - sheet), my date is "july 7th...the formula is only filtering by "7th" and not by july. for example, in the "master" sheet, if you filter by "test1" - column C ; "7th" - column G ; "-" in july - column AI, you should get 3 names, however in my attached, it is only getting one name, as the formula is not dependent on "july 7th"

can someone pls help?

see sample attached.

any thoughts on this...thx u

yes you are right.

in the "master" sheet, the months are located in row 7 and the billing date is in range F9 down.

I am not sure how to integrate the two together in the formula?

ur thoughts...thx u

would it possible to include that portion in my formula??

someone pls help!!!!