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

question by: Arun K Narayan
https://productforums.google.com/forum/#!topic/docs/71JKWLCZX1U;context-place=forum/docs

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.