2 Replies Latest reply: Nov 27, 2012 5:54 PM by Bobhurtt
Bobhurtt Level 1 Level 1 (0 points)

I'm kinda new to numbers on my iPad. I'm trying to change values in cells based upon the selection of a pop up menu. I'm sure this is simple, what am I missing?

I have about 50 items (prices, descriptions, etc) and would like to create a pop up on sheet1 that will bring forward the correct values in subsequent cells....


iPad 2
  • Wayne Contello Level 6 Level 6 (16,365 points)

    Are you having trouble with the popup or using the popup in another formula?

  • Bobhurtt Level 1 Level 1 (0 points)

    I can create the pop up list, but I want to figure out how to change the other cells based on the content of the pop up.

    For instance, product xxx is selected from the pop up list in a1, I would want a2 to show the corresponding price (as listed on sheet2) and the correct manufacturer and description in a3 and a4. All of the info is in a table on sheet2 so the function on sheet1 would bring forward the correct row of information that corresponds to product xxx's row on sheet2.