Using multiple drop-downs to filter list to produce final unique list

[goldyc87]

I'm working on a project that requires modeling a basic multiple-input and multiple-output engine via Excel.

To keep things simple, let's use the following as a proxy:

Given:
100 unique people.

Solve for:
Individuals of the 100 who fit certain characteristics:

Characteristics:
Physical
Eye color (blue, brown),
Height (below 5', between 5' and 6', taller than 6')
Hair color (white, blonde, brown, black)
Emotional
Social (outgoing, shy)
Expression (verbal, nonverbal)

Where I am:
Multiple dependent drop-down menus for each characteristic using named lists and data validation
EX:
I can tell you the names of the 23 people with brown eyes, the 15 people taller than 6', OR the 33 people with black hair in drop down menu form

Where I want to be:
A single list that identifies the 7 people with brown eyes AND taller than 6' AND black hair by name/in list form!

Issue:
I need a list as an output, not a single value output.

I would prefer NOT to make this into an absurdly-long conditional statement (IF blue eyes, THEN white hair OR black hair OR...etc)

Thank you so muuch!!!!

----

PS: Actual engine has many many more variables and lists

 

[Latchmaker]

I would assume you have seperate columns for each trait....for example eye color has its own column of data, height has its own column of data and so on....if so use the filter function and select a criteria for each column this will create your list