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" wrote:

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

--
Ian
--
"KG121953" wrote in message
...
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"....