lookup - sort help

[clundeen]

I am struggling getting a formula to load cells B2, B3, C2, C3 in (WS-subsheet) with the lowest ranking to highest ranking from (WS rankings) column A if it has a number that matches what is entered in (WS-subsheet) cell A2 - Using the following (file attached) but open to any suggestions -

Since this WS will be a subsheet, I could have if take first name from column D in Rankings! that has a 1 in column G for B2, second name that has a 1 in column G for B3.....

=INDEX(Rankings!$D$2:$D$85,SMALL(IF(Rankings!$G$2:$G$85=$A$2,Rankings!$A$2:$A$85),ROW(A1)))

=INDEX(Rankings!$D$2:$D$85,LARGE(IF(Rankings!$G$2:$G$85=$A$2,Rankings!$A$2:$A$85),ROW(A1)))

=INDEX(Rankings!$D$2:$D$85,SMALL(IF(Rankings!$G$2:$G$85=$A$2,Rankings!$A$2:$A$85),ROW(A2)))

=INDEX(Rankings!$D$2:$D$85,LARGE(IF(Rankings!$G$2:$G$85=$A$2,Rankings!$A$2:$A$85),ROW(A2)))