How do I link cells to specific choices from a drop down menu in Numbers for ipad
For example, if I made a spreadsheet for nutrition and I had a drop down list that contained certain fruit (apple, orange, banana). Let's say I chose "apple", how would I get the rest of the fields to auto-populate with nutritional information for an apple like calories, sugars, fat, etc.
i would have a separate sheet done up with all of this info, and with the appropriate fruit as the "header", but is there a way that I can link the drop down options in the first sheet with their respective info, and they would just populate in the first sheet?
iPad mini 2 Wi-Fi, Cellular, iOS 8.4