Hi

Dashboard!B10:
=IF(ROW()-9>COUNTIF(BI!$C$9:$C$5000,DASHBOARD!$I$2),"",INDEX(BI!$B$1:$B$5000,SMALL(IF(BI!$C$9:$C$5000=DASHBOARD!$I$2,ROW(BI!$C$9:$C$5000)),ROW()-9)))

Dashboard!C10:
=IF(ROW()-9>COUNTIF(BI!$C$9:$C$5000,DASHBOARD!$I$2),"",INDEX(BI!$G$1:$G$5000,SMALL(IF(BI!$C$9:$C$5000=DASHBOARD!$I$2,ROW(BI!$C$9:$C$5000)),ROW()-9)))

The ROW()-n has to equal 1 for the first appearance of the formula. So if the formula appears in row 10, then n has to be 9. If it is in row 3, then n has to be 2.

Also, the range being indexed has to start from row 1. This is because the result from the if statement returns the row number. To make the index work the range has to start from row 1.

HTH

rylo