Getting a yes/no for repeating items based on criteria

[istank]

I am requesting help getting a YES/NO based on repeating items with unique categories where only one item can include the yes.

I have a table with a drop down of BASE, ALT, ADD. Producing YES/NO from the BASE was easy. Producing YES/NO when each item only had 2 categories was easy. It is the 3rd category which is throwing me off. I need to do this as a formula within the include column.

Please see the below examples. here is a editable version: //1drv.ms/x/s!AuSAY8w45lIm_RTA8v2IDmdMC59g just missing the "https:" dont have enough posts yet to share a link properly

Any help would be greatly appreciated.

My values are located in the following cells:


a b c
1 Select: BASE
2
3 Item Category Include
4 a BASE YES
5 b BASE YES
6 b ALT NO
7 c BASE YES
8 c ADD NO
9 c ALT NO
10 d BASE YES
11 d ADD NO


What I need to do is when I change the selection box to for example base, all the items that are base need to say YES in the include column and NO for the non base items as in the above example.

When I select ALT, it needs to say YES for those items that either only have a BASE or if they have a multiple options the ALT line needs to say YES while the others say NO as in the below example.

a b c
1 Select: ALT
2
3 Item Category Include
4 a BASE YES
5 b BASE NO
6 b ALT YES
7 c BASE NO
8 c ADD NO
9 c ALT YES
10 d BASE YES
11 d ADD NO

When I select ADD, it needs to say YES for those items that either only have a BASE or if they have a multiple options the ADD line needs to say YES while the others say NO as in the below example.

a b c
1 Select: ADD
2
3 Item Category Include
4 a BASE YES
5 b BASE YES
6 b ALT NO
7 c BASE NO
8 c ADD YES
9 c ALT NO
10 d BASE NO
11 d ADD YES

[ben_hensel]

This formula will match the written description of what you require:

Please Login or Register  to view this content.

Note that, as far as I can tell, your written description and your examples disagree in the case of:
Row 11 ("d" & "Base") for B2 = ALT
Row 6 ("b" & "Base") for B2 = ADD

[istank]

I did check the values and I think I got it right as to you comments about the mismatch between examples and description.

Thanks for the help with that formula but is there a way I can modify this to work in the event I have to add more drop down options? The formula worked perfect but it has absolute variables such as "BASE" and seems to require extension of the formula if I add an option of lets say "BASE 2".

[istank]

Doing some searching and trial and error I solved the issue.

Sadly It will not let me post the solution because I don't have a high enough post count.