Skip,
I ended up doing this, where Code is my named range row where the Code values are and Selected is my named range row where the Selected Values are.
=IF(COUNTIFS(Code,INDEX(Code,MATCH(1,Selected,0)),Selected,1)>=SUM(Selected),INDEX(Code,MATCH(1,Selected,0)),"Mixed")
The issue is there...