How to find the value of the second element with IFS?

Question

Google Sheets

Tell me how you can find out the value of the second element when choosing through IFS
For example: there is a list of employees in front of each checkboxes, you need to display below, a list of all employees in front of which there are marked checkboxes. (for the first employee, everything is simple, with the second one there is a problem)
And is it possible to somehow limit the number of checked checkboxes so that it would be possible to put only 2 checkboxes in a certain range?

Answer 1

Thank you, this is based on checkboxes and visualization so that there is no more than 2, how to display the second marked employee?

Answer 2

Format - Conditional Formatting
Apply to range
Format rules
And red fill
This will keep track of the number of checkboxes. You can even set conditional formatting several times with different colors for different numbers (or use a gradient)
Or another crutch that will allow you to put a daw, but will not take it into account if there are 2 or more installed

ИСТИНА	=СЧЁТЗ(filter($D$1:$D1;$D$1:$D1=ИСТИНА))<=2	=И(D1;E1)
ЛОЖЬ	=СЧЁТЗ(filter($D$1:$D2;$D$1:$D2=ИСТИНА))<=2	=И(D2;E2)
ИСТИНА	=СЧЁТЗ(filter($D$1:$D3;$D$1:$D3=ИСТИНА))<=2	=И(D3;E3)
ЛОЖЬ	=СЧЁТЗ(filter($D$1:$D4;$D$1:$D4=ИСТИНА))<=2	=И(D4;E4)
ИСТИНА	=СЧЁТЗ(filter($D$1:$D5;$D$1:$D5=ИСТИНА))<=2	=И(D5;E5)
ИСТИНА	=СЧЁТЗ(filter($D$1:$D6;$D$1:$D6=ИСТИНА))<=2	=И(D6;E6)
ИСТИНА	=СЧЁТЗ(filter($D$1:$D7;$D$1:$D7=ИСТИНА))<=2	=И(D7;E7)
ИСТИНА	=СЧЁТЗ(filter($D$1:$D8;$D$1:$D8=ИСТИНА))<=2	=И(D8;E8)
ИСТИНА	=СЧЁТЗ(filter($D$1:$D9;$D$1:$D9=ИСТИНА))<=2	=И(D9;E9)

The third option is to track the onEdit (event) event and resolve everything with a script