IFS formula with multiple column lookups

I am trying to do a lookup in one column and return a value from one of five other columns based on the lookup value. The "Score in Dept" should return the value based on "Dept Collapsed". So in the ...