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

13 thoughts on “Return multiple values based on single criteria

  1. ig

    If you would like to improve your familiarity only keep visiting
    this web page and be updated with the most up-to-date news posted here.

  2. Philipp

    Its like you learn my thoughts! You appear to understand
    so much about this, like you wrote the guide in it or something.
    I feel that you can do with a few % to force the message home a little bit,
    but other than that, that is great blog. An excellent read.
    I’ll certainly be back.

  3. sling tv

    Hey I know this is off topic but I was wondering if you knew of any widgets
    I could add to my blog that automatically tweet my newest twitter updates.
    I’ve been looking for a plug-in like this for quite some
    time and was hoping maybe you would have some experience
    with something like this. Please let me know if you run into anything.
    I truly enjoy reading your blog and I look forward to your new updates.


    I really like your blog.. very nice colors & theme. Did you
    make this website yourself or did you hire someone to do it for you?
    Plz answer back as I’m looking to design my own blog and would like to
    find out where u got this from. thank you

  5. sling tv

    Terrific work! This is the kind of information that
    are meant to be shared around the web. Disgrace on the search
    engines for not positioning this put up upper! Come on over and
    seek advice from my website . Thank you =)

  6. coconut oil

    Good day! Do you know if they make any plugins to help with Search Engine Optimization? I’m trying to get my blog
    to rank for some targeted keywords but I’m not seeing very
    good results. If you know of any please share. Thanks!

  7. Janna Carinio

    There are certainly a lot of details like that to take into consideration. That is a great point to bring up. I offer the thoughts above as general inspiration but clearly there are questions like the one you bring up where the most important thing will be working in honest good faith. I don?t know if best practices have emerged around things like that, but I am sure that your job is clearly identified as a fair game. Both boys and girls feel the impact of just a moment?s pleasure, for the rest of their lives.

  8. ps4 games

    Great post. I used to be checking continuously this blog and I am impressed!
    Very helpful information particularly the remaining part :
    ) I take care of such info much. I used to be seeking this certain information for a long time.
    Thanks and best of luck.

  9. 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

Comments are closed.