Drop down Box / Functions

[Guest]

HELP Please
This is what I would like to do...
Example:
"C6" is a drop down menu for design type Designs are listed as 4000, 6000,
3500...Each have a deferent price/per that needs up dating
I don't want to put in cost every time I price out a job. I would like
"4000" in the drop down menu to refer to cell "G15" where the price / per is
entered when price is updated
So in Total price (Lets say cell "F24") "F24" would be =SUM(C6, (K5:K11))*C9
(“C9†amount of)
6000 would be "G16", 3500 "G17â€....

 

[Ian]

Your query isn't clear.

"C6 is a dropdown menu" Are you using data validation? Where is the list. Is
it in column F (ie adjacent to the prices)?

"=SUM(C6, (K5:K11))*C9" - what is in K5:K11?

Assuming I am correct in my assumptions above, you need to use data
validation to fill the drop down menu from column F15, F16, F17 etc, then
use =VLOOKUP(C6,F15:G17,2,FALSE)*C9 in F24

 

[Guest]

I don't know if this will clear this up
Example; Cell C6 is drop Down box Created in data validation
C9 is where I would inter the # of units
F4 would then be the total cost
when updating my suplier price list I would then enter the design cost in
cells as fallows
4000 G15, 6000 G18, 3500 G19......
C9 list woud read 4000, 6000, 3500....
By choosing 4000 the value of C6 would be the same as G15
(K5:K11) are cell that I would enter other price factors }
Yes I know "I'm not the sharpest knife in the draw.
Thank for your resonce I hope that this helped clear things up

 

[Ian]

I may be misunderstanding, but if you have the data validation drop down in
C6, you can't have the value of another cell in there as well. You need to
relate G15 with 4000, G18 with 6000 etc., but I don't see how you are doing
that. What you would need is a table with the designs in one column and the
prices in the next (ie 4000 in F15, 6000 in G18 etc), then use a vlookup
similar to the one I suggested. Your "other price factors" remain a
confusion. What are they, and what are you doing with them? Are they
multiplication factors? If so, what are you multiplying?