Using drop down options to pull data

[politicalangel]

Creating a summary tab that pulls data using the drop down options.
I have historical data that I would like to summarize using drop down options.
I want to be able to select a region and customer typ and have the top 3 customers for that region and specific customer type pull. Please see attachment for example.
Like always your help is greatly appreciated

Thanks!

 

[bosco_yip]

Try.......

1] Helper column, "Rank of FY" J3, copy across and down :

=COUNTIFS($C$3:$C$18,$C3,$F$3:$F$18,$F3,G$3:G$18,">"&G3)+COUNTIFS($C$3:$C3,$C3,$F$3:$F3,$F3,G$3:G3,G3)

2] "Output result" P6, copy across to Q6 and down :

=IFERROR(INDEX(D$3:D$18,MATCH(1,INDEX(($C$3:$C$18=$P$1)*($F$3:$F$18=$P$2)*(CHOOSE(MATCH($P$3,$G$2:$I$2,0),$J$3:$J$18,$K$3:$K$18,$L$3:$L$18)=$O6),0),0)),"")

3] "Output result" R6, copy down :

=IFERROR(INDEX(($G$3:$G$18,$H$3:$H$18,$I$3:$I$18),MATCH(1,INDEX(($C$3:$C$18=$P$1)*($F$3:$F$18=$P$2)*(CHOOSE(MATCH($P$3,$G$2:$I$2,0),$J$3:$J$18,$K$3:$K$18,$L$3:$L$18)=$O6),0),0),0,MATCH($P$3,$G$2:$I$2,0)),"")

Regards
Bosco