First, take a look at Debra Dalgleish's Order Form example:
http://www.contextures.com/xlOrderForm01.html
It explains how to select items from a dropdown list and display
corresponding prices.
Is that something you can work with?
Post back if you have more questions.
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"Steve_Dallas" wrote in message
...
I'm in the AV business and I am creating a room/speaker worksheet where on
Sheet 1, there is a drop down cell for each room that references a list
from
Sheet 2 of (1) available speaker types and (2) the added price so that I
can
chage it from time to time. Column A would be Classic, Architectual,
Extreme,
Yard and column B would be $0, $400, $600, $800 respectively.
The resulting drop down name on Sheet 1 would be a combination of the 2
columns from Sheet 2. For example "Classic ($0)" or "Yard ($800)" with the
parenthesis.
Once 1 of the 4 is chosen, I would like that cell to have the dollar value
that it represents so that after selecting the type of speaker for each
room
there will be a total of added expense at the bottom of the form.
Thank you in advance!