Function based on Partial Match Range

I am trying to do a calculation based on a range that needs to be identified via a partial match. I've tried many options, including the following function:
{=MEDIAN(INDEX($C$2:$C$6,MATCH(CONCATENATE("*",$E2,"*"),$B$2:$B$6,0)))}

However, this does not give me the correct answer, since it merely takes the first occurance of the match. How can I create a function that will identify a range? I have attached a sample spreadsheet.