Saturday, April 14, 2018

yogi_From A DropDown List Of Categories Choose Item Selected And Associated Product And Price

Google Spreadsheet   Post  #2425

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Apr-14-2018
Hi can someone help me. I am trying to create a dependable drop down list in google sheets
For example, I have dropdown lists like the ones specified

Column A .  Column B  Column C . Column D
Apple            Fruit              Juice         $10
Tomato .       Vegetable      Salad        $15
Potato .         Vegetable .    Salad        $15
Chicken        Meat              Meal          $20
Beef              Meat              Meal          $18
Milk               Dairy             Drink          $6

What I would need is if I choose Tomato in column A, The drop down in column B should only show Vegetable Columns C should show only one value Salad and column D dropdown list will have only one value i.e. $15

Is this possible. If yes please help.