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
Hi Sapainters,
This might be what you want:
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)," ")
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.
Hi Sapainters,
This might be what you want:
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)," ")
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.
thanks ian ,
i kinda understand ill have a play around on it now , is it possible to put the "database" on a different sheet so that way when using on the ipad its like the last tab of all ?
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
yeh just realised you can move it between sheets 😀 thanks
btw ill be back again lol !
this is what I need to do, but your instructions are pretty vague (for me, anyway). I've followed your diagram, but no such luck. is it possible to dummy this down a bit? thanks.
never mind. solved.
adding values to pop up menus
