What do you mean is it a variable? Essentially this is what I want:

Material Price
Vinyl $5
Copper $7

where under the material heading those items are in a drop down, I don't
care about the prices if they are in a drop down or not.

Thanks

"John C" wrote:

Is the price of the material a variable? If not, why would you want a drop
down box for the price of the material. Once you bring over the material, you
could do a VLOOKUP or something in regards to the price.
--
John C


"Vasu" wrote:

Hey All,

I need help with linking drop down boxes.
I have created a drop down box for materials and another one for the price
of material. What I would like to happen is when I select the material the
drop down for the price of material should only show the price for that
material. Can somebody please help me implement this, I am currently using
Office 2003.

Thanks
Vasu