Generate a list based on two optional conditions

[csktwyr]

Normally what we do is two or more sets of list generate depending on the value in the cell.

Ex. If A1 = Coffee then B1 will show a list of flavors of coffee, if A1 = Juice then B1 will show a list of flavors of juice

What I want to get is the reverse.

Now, what I would like to happen is if the cell value in A1 = Coffee, then it will generate a list in B1, let's say Sachet and Jar.

But if I put in cell A2 = Juice, I would want B1 to generate the same list as well. And if I put different values to A1 and A2, then B1 will not generate a list.

I only want the list to generate from B1 and nowhere else.

Is it possible? Any help is greatly appreciated!

 

[alansidman]

It would be very helpful if you attached a sample file using xl2bb. The sample should contain 8-12 records that are representative of your actual file. Once you have upload that, then please mock up what your solution should look like and use XL2BB to upload that information