Trying to create spreadsheet that uses 3 different criteria to return a value

I am confused as to why payroll 13 was given 38 C when the first choice (cell G8) appears to be 62 C which is open and not selected by payroll 12.
Also confused that payroll 13 has two class ranks (6 and 48).