Array look up with multiple values and multiple look up

[anothermarksmith]

First post on this forum.

I have the following table of data
datatable.PNG

and the following results table
results.PNG

I am using this array formula to give me the results shown:

{=IF(ROWS(A$6:A6)<=COUNTIF(data!$C$2:$C$23,results!$B$1),INDEX(data!A$2:A$23,SMALL(IF(data!$C$2:$C$23=results!$B$1,ROW(data!$C$2:$C$23)-ROW(data!$C$2)+1),ROWS(A$6:A6))),"")}

This formula works but what I want to do is when there are multiple criteria ( multiple weeks) that it will move down the list of weeks and give the results as shown below.

results 2.PNG

Thanks for any help!
example file attached as well.

[Jacc]

It says you are using Excel 2010 so I saved it in that format so that I could use IFERROR.

I'm tired now so a helper column seemed like a good enough solution.

[anothermarksmith]

Thanks that did it!!

[Jacc]

--------