How to search through items with the same value to see if the meet criteria?

Hi,

I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m having is that the search stops at the first match, so, if this is a FALSE, the answer is returned as FALSE. Even if the next match would return a TRUE result. 

I’ve created a scenario below to try and illustrate the problem: 

Excel_Question_Example

In column A I’d like to return a Y/N answer to whether the ‘Animal Type’ adjacent, in column B, has ever won the olympics.

I’ve tried using the ‘if’ and ‘Match Index’ functions, but the formula stops at the first match it finds in the column. 

For example, the dogs in row 2 and 5 have not won the olympics, but the dog in row 6 has; the actual answer to the question of whether a dog has ever won the olympics is ‘Y’ (yes), but with the ‘IF’ and ‘Index/match’ functions the answer returned is ‘N’ (No)

Does anyone have a formula that would be able to search through all the instances of ‘Dog’ in Column B to see if there is any instance where ‘Dog’ has ‘Won the Olympics’ (C=”Y”).

Could this formula then be translated to other cells, so, in row 3, a Y/N answer will be returned for whether ‘man’ has won the Olympics?

Any assistance would be gratefully received. Also, if the above is unclear, I’m happy to try and explain further.

 

Many thanks!

 

By: Beth

16 thoughts on “How to search through items with the same value to see if the meet criteria?

  1. ig

    I was suggested this blog by my cousin. I am not sure whether this post is written by him as nobody else know such detailed about my
    difficulty. You’re amazing! Thanks!

  2. http://mychat.fun

    My partner and I absolutely love your blog and find the majority of
    your post’s to be just what I’m looking for. can you offer guest writers to write
    content for you? I wouldn’t mind composing a post or
    elaborating on some of the subjects you write regarding
    here. Again, awesome web site!

  3. http://tinyurl.com/sling-tv-48639

    Great post. I used to be checking constantly this blog and I am inspired!
    Very useful information specifically the remaining section 🙂
    I maintain such info much. I used to be looking for this particular info for a
    long time. Thank you and good luck.

  4. plenty of fish vs match.com free trial

    hello there and thank you for your information – I have certainly picked up something new from right here.

    I did however expertise several technical issues using this web site, as I experienced to
    reload the website many times previous to I could get it to load properly.
    I had been wondering if your hosting is OK? Not that I am complaining, but sluggish
    loading instances times will very frequently affect your placement in google and could damage your high quality score if advertising and marketing with Adwords.
    Anyway I am adding this RSS to my email and can look out for much more of
    your respective exciting content. Make sure you update this
    again soon.

  5. match.com free trial

    Hi there I am so delighted I found your webpage, I really found you by error,
    while I was searching on Google for something else, Anyways I am here now and would just like
    to say cheers for a marvelous post and a all round enjoyable blog (I also
    love the theme/design), I don’t have time to read it all
    at the moment but I have bookmarked it and also included your RSS feeds,
    so when I have time I will be back to read much more,
    Please do keep up the superb b.

  6. coconut oil

    I will immediately snatch your rss feed as I can not find your email subscription hyperlink
    or e-newsletter service. Do you’ve any? Kindly let me realize so that I may subscribe.
    Thanks.

  7. quest bars cheap

    I have been surfing online more than 4 hours today,
    yet I never found any interesting article like yours. It’s
    pretty worth enough for me. In my opinion, if all website owners and bloggers made good content
    as you did, the net will be a lot more useful than ever before.

  8. quest bars cheap

    I have been exploring for a little for any high-quality articles or weblog posts on this sort of
    house . Exploring in Yahoo I eventually stumbled upon this website.
    Studying this info So i’m glad to show that I have an incredibly just right uncanny feeling I found out just what I
    needed. I so much without a doubt will make
    sure to do not omit this site and give it a look regularly.

  9. coconut oil when

    Please let me know if you’re looking for a author for your site.
    You have some really great articles and I feel I would be a good asset.
    If you ever want to take some of the load off, I’d love
    to write some articles for your blog in exchange for
    a link back to mine. Please blast me an e-mail if interested.

    Many thanks!

Comments are closed.