dynamic CONDITIONAL dependent list

Hello!

Id like to make a dependent list where you would choose an ability or (service) and then could choose the right person according to it

that is easy to make but not with the following conditions:

the names of the abilities and people can be changed at any time

abilities and people can be added/removed

people can learn new abilities thus i have to be able to change what they can do or not and thus change the list again thats the reason

i would like to only use one table



here is what i came up with:
i made a table with YES and NO options for all people and abilities.
Could i use some kind of IF function that defines to only let names on the list that have a YES in the right place?

Its hard to explain so take a look yourself

EXAMPLE
i choose ability3 in the first drop list, the second drop list should only offer me the names of the people that have YES assigned there

----------------------------------------

It should be dynamic so that if i change an ability, name, or yes or no, the drop list should adjust

the choices are in the MATH sheet, the results can be on a different sheet

Thanks for the help