Index Match Match with rank check

Hello people.

I need to match value on one set of variables within that range I need to return a values that is ranked according to another variable.

Hopefully the workbook explains it better than me.

I believe that index match match can solve this issue, but I haven't been able to figure it out.

Thanks!