Skip navigation

adding values to pop up menus

292 Views 4 Replies Latest reply: Jul 4, 2013 3:28 AM by Sapainters RSS
Sapainters Calculating status...
Currently Being Moderated
Jul 3, 2013 10:10 PM

is it possible to assign a value to a pop up menu item 

 

say you have a product = bar of soap type 1 in cell A from a pop a menu

 

but i want the price of "bar of soap type 1 " to appear in cell D

 

in other words id like to impletment a product / and price list on command

iMac, iOS 6.1.4
  • Yellowbox Level 4 Level 4 (3,900 points)
    Currently Being Moderated
    Jul 4, 2013 2:22 AM (in response to Sapainters)

    Hi Sapainters,

     

    This might be what you want:

     

    Screen Shot 2013-07-04 at 7.14.01 PM.png

    The Price List Table is a database of stock and prices.

     

    The Order Table is where you have Pop up menus to select a customer's order.

    The first item in each Pop up is a space (if nothing is selected, the Cell appears blank).

     

    The price lookup is done in Column B of the Order Tabler:

     

    =IFERROR(VLOOKUP(A2,Price List :: A:B,2,0)," ")

     

    Screen Shot 2013-07-04 at 7.15.25 PM.png

     

    IFERROR() places a space in the Price Column (B) if nothing is selected from the Pop up in that Row.

     

    Fill Pop ups and formulas down.

     

    Choose "blank" from all Pop ups then Save As Template.

     

    Regards,

    Ian.

  • Yellowbox Level 4 Level 4 (3,900 points)
    Currently Being Moderated
    Jul 4, 2013 3:21 AM (in response to Sapainters)

    Hi Sapainters,

     

    Thanks for the feedback. I did that on a MacBook Pro (OS X operating system). It's easier to have the two Tables on view when setting up the document, and yes I would then move the database to a different sheet. On Mac, formulas continue to work between sheets. I don't know how iPads work, but it seems a good idea to hide the database table if you can. Then your doc will look tidier.

     

    Regards, and Happy Numbers!

    Ian

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.