Excel Combo-Box

[Sam]

How do I use the data in a combo-box as a link. I have to create an excel
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]

Hi Sam

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

 

[JulieD]

Hi Debra

or "combo boxes" created via data / validation.

Cheers
JulieD

 

[Debra Dalgleish]

Note that Julie's solution assumes you have used combo boxes from the
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.

 

[Sam]

Thank you both for your help. I am a lot more confident and successful in my
work now. Sam