Return multiple values based on single criteria


Let’s say I have this data set:

Name First Trait Second Trait Third Trait Fourth Trait Fifth Trait
Alison Learner Restorative Relator Arranger Input
Ashli Relator Deliberative Futuristic Intellection Strategic
Brian Strategic Command Restorative Self-Assurance Adaptability
Catherine Relator Empathy Consistency Includer Harmony
Chian Restorative Learner Intellection Input Responsibility
Congyu Restorative Achiever Relator Intellection Learner
Darbara Restorative Arranger Responsibility Learner Ideation
Darren Analytical Ideation Futuristic Communication Learner
Dwayne Belief Intellection Learner Competition


I want to do a search in a different sheet that basically says: for this person: (Alison), what are her traits and who has the same traits. I can do data validation to choose the name in the other sheet. 


Any help would be appreciated.


Thank you!

By: Bob

2 thoughts on “Return multiple values based on single criteria

  1. coconut oil what

    Excellent weblog here! Additionally your website quite a bit up very fast!
    What web host are you using? Can I get your associate link for your host?

    I wish my web site loaded up as quickly as yours lol

Leave a Reply

Your email address will not be published. Required fields are marked *