Multi dependent dropdowns with auto-generated cell

Hi All,

I have a product catalogue with upgrades options that I am trying to create a dropdown table where you can select information from a master table in column A and B and it will provide an auto-generated answer in column C depending on the inputs of A & B.
So on the dropdown tab they will be dropdowns on column A & B which will auto populate C.

I have looked at data validation with dropdown lists, but this doesn't answer the auto-generation of the option Yes/No depending on column A & B.

I have attached an example SS based on food choices.
So in my original SS, I am trying to ask the master table "If I have this product x and I want to upgrade it to product y, is this possible?".
But in this example SS, I am trying to ask the master table "If I go to restaurant x and I want to order food y, is this possible?"


Thank you for your help!

- Al

in C3

=INDEX(Master!$B$3:$H$7,MATCH(Dropdown!$A3,Master!$A$3:$A$7,0),MATCH(Dropdown!$B3,Master!$B$2:$H$2,0))

Just one table - no on-sheet formula.
It does not matter if you add another to the bottom of the table out of order the combos will deal with the sort.
torachan.

Originally Posted by JohnTopley

in C3

=INDEX(Master!$B$3:$H$7,MATCH(Dropdown!$A3,Master!$A$3:$A$7,0),MATCH(Dropdown!$B3,Master!$B$2:$H$2,0))

Hi JohnTopley,

This formula does indeed work, thank you!

Originally Posted by ChemistB

Do you also need help with generating the dropdown lists? Do you want those lists to update automatically if you add more "restaurants" or "food choices?"
Set up a defined name Restaurants, "refers to"
=Master!$A$3:INDEX(Master!$A$1:$A$100, COUNTA(Master!$A$1:$A$100)-1)

Food
=Master!$B$2:INDEX(Master!$B$2:$Z$2, COUNTA(Master!$B$2:$Z$2))

Hi ChemistB,

In regards to the dropdown list, I have just made a separate tab and copied the headers from the master table and done a data validation.
I would quite like the option to have an automatic update feature as the table continues to grow.

Originally Posted by torachan

Just one table - no on-sheet formula.
It does not matter if you add another to the bottom of the table out of order the combos will deal with the sort.
torachan.

Torachan,

This does look very good, thank you for taking the time to provide this.
I have no experience with macros / widgets before but I would like to start.

On the original SS I am working on there are a few more options other than "NO" or "YES" for availability.
How did you create this table with all the corresponding options?

The table is your original with some of the data transposed.
In this format the array loading the comboboxes is just filtered accross its columns - 'the raw power of VBA'