Matching Text & Applying Criteria On Row

Hello,

I'd like to return an average by matching the text in the small table to a row of cells in my larger table of test scores.

Once the row has been identified I'd like to average the values for a certain period using several criteria, for example >=11 and <=15 within the formula for easy amending this going forward, but this is not essential.

Looking forward to hearing from you.