Excel Combo-Box
Sam
production for a college project and it requires me to create a pricing sheet
for a business. I want to have details in the combo-box which are linked to
prices on another sheet so that when you have selected the details you want
in each combo-box they are linked to a final cell on the sheet so they create
a final total price. Can anyone help me please. Thanks
Sam
JulieD
this is generally done through the VLOOKUP function. what i would do is a
price for each line item (and mutliply it by quantity as well)
so say your list of products and prices is on sheet3
A........B
Product.....Price
and on sheet 1 you have the combo box in cell A16 and you want the unit
price to appear in B16
the formula in B16 would be
=VLOOKUP(A16,Sheet3!$A$2:$B$1000,2,0)
this says, lookup the value in A16 in the table in sheet3 and return the
information from the second column where there is an exact match
you will have to embed this in an IF statement to supress the display of #NA
when there is nothing in A16 but as this is a college project i'll let you
work on this bit of it on your own :)
Cheers
JulieD
"Sam" <S...@discussions.microsoft.com> wrote in message
news:DFA31262-F81A-474C...@microsoft.com...
Debra Dalgleish
Control Toolbox, and each combo box is linked to the cell under it.
To link to a cell, click the Design mode button on the Control toolbox
Select a combo box, and click the Properties button on
the Control toolbox
In the list of properties, find LinkedCell, and enter the cell reference
After all the combo boxes are linked to cells, click the
Exit Design Mode button on the Control toolbox.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
JulieD
or "combo boxes" created via data / validation.
Cheers
JulieD
"Debra Dalgleish" <d...@contexturesXSPAM.com> wrote in message
news:419DF96F...@contexturesXSPAM.com...