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:

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

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