Retrieving Top 8 Values while meeting a criteria (Index / Match Formula)

Hi All,

Good day to you.

I am currently trying to get the names of the top 8 bowlers based on total score (Column G) for a division "Civ" (Column B) with the "Index/Match" formula but am failing badly.

As you can see in cells, H27:O31, I am currently able to get some of values correctly but am facing some errors.

1) First value in I28 is returning N/A value
2) Cells K28 - M28 is returning N/A value as well
-> this is because it is showing the top values of the other divisions as well which I do not wish to see.

Seeking your kind assistance, please!

Regards,
Joseph