Index Match multiple criteria, multiple results

[rugbytomc]

I have a formula
=INDEX(Sheet_1_crosstab.csv!$D:$D,MATCH(1,(A2=Sheet_1_crosstab.csv!$B:$B)*(B2=Sheet_1_crosstab.csv!$C:$C),0))

It's great for giving me the first result from Column D in my Sheet_1)crosstab.csv that matches my 2 different criteria. What I can't figure out is how to get the 2nd, 3rd.....xth result (should there be one) as well.

I don't mind how that looks, either the result in the next column or in the same cell with a comma etc etc

Any help much appreciated!

Thanks
Tom

 

[Special-K99]

Try (untested)

in E1
=IFERROR(INDEX(Sheet_1_crosstab.csv!$D1:$D1000,SMALL(IF((A2=Sheet_1_crosstab.csv!$B1:$B1000)*(B2=Sheet_1_crosstab.csv!$C1:$C1000),ROW($A$1:$A$1000)),ROW(A1))-(ROW(A$1)-1),1),"")
Array formula, use Ctrl-Shift-Enter

or if you can use AGGREGATE

=IFERROR(INDEX(Sheet_1_crosstab.csv!$D1:$D1000,AGGREGATE(15,6,ROW(A$1:A$1000)/((A2=Sheet_1_crosstab.csv!$B1:$B1000)*(B2=Sheet_1_crosstab.csv!$C1:$C1000)),ROWS(A$1:A1000))-(1-1),1),"")
non array formula

copy down the column for however many solutions you think there will be
Array formulas will be slow.