Just to confirm that I have this right,

you wish to:

Auto populate a cell based on multiple conditions such as gender restriction, age group restriction and find the person with the highest score within that?