Therealmahoney

Q: 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

Posted on Aug 5, 2015 9:28 PM

Close

Q: How do I link cells to specific choices from a drop down menu in Numbers for ipad

  • All replies
  • Helpful answers