index small issue - with multiple criterias

[jw01]

hello

have some trouble trying to add multiple criterias to my formula.

in my "master" sheet aka raw data, i have list of names and their invoice.

i would like to know from the list in the "missed accounts" worksheet, based on user "cell D9" and date cell "D11" a list of the account names in cell F15 down....and if i select i.e. Jan 1st from cell D9, then in column G15 down, list the accounts that are "blanks or do not contain data".

in my master sheet, i do not have a range that says "January 1st, Janary 15th etc" - these are the the invoice dates (1st, 7th, 15th, 22nd)

the months are listed in the "master" sheet in row & i.e. K7. I need to in my formula merge the data to say K7&" "$G$9:$G$112"

here is my formula:
{=IF(ROWS($15:15)>COUNTIF(Master!$G$9:$G$470,$D$11),"",INDEX(Master!G:G,SMALL(INDEX(ROW(Master!$G$9:$G$112)+(Master!$G$9:$G$112<>$D$11)*10^10,0),ROWS($15:15))))}

I have attached my workbook. can someone pls help!

[jw01]

any thoughts on this guys?

[:) Sixthsense :)]

Please add some expected results for 3 or 4 rows which will be helpful to check and provide solution quickly.

[jw01]

Please add some expected results for 3 or 4 rows which will be helpful to check and provide solution quickly.

hello

thxs for your help.

please see the attached workbook. i have copy/pasted the results for i.e. Jan 22nd billing date. I have populated the table till march as an example.

it shows for the date selected "Jan 22nd" > by name "test1" > the missed billed or "blanks or "-" from the master sheet.

as you will notice, there are blanks in month of jan, however feb and march contain data.

hope that makes sense. that is what i am trying to achieve from formula...pls help!

[jw01]

any help on it? thxs

[jw01]

any thoughts or ideas guys? thx u