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