I confess I'd probably use a single column of helpers eg

L2: 
=LOOKUP(10,CHOOSE({1,2,3,4},0,1*(MATCH(TRIM($D2)&"*",List!$A$1:$A$20,0)>0),2*(MATCH(TRIM($D2)&"*",List!$B$1:$B$20,0)>0),3*(MATCH(TRIM($D2)&"*",List!$C$1:$C$20,0)>0)))

H2:
=IF($L2=0,"?",TRIM(RIGHT(TRIM(INDEX(List!$A$1:$C$20,MATCH(TRIM($D2)&"*",INDEX(List!$A$1:$C$20,0,$L2),0),$L2)),3)))

I2:
=INDEX({"Country","Metro","Bush","Provincial"},1+$L2)

J2:
=IF(WEEKDAY($B2,2)<6,"Weekday","Weekend")
H2:L2 copied down to H2:L8
note: for State where type is Country I've left as "?" as there is seemingly no way of determining the appropriate value.