Help With Linking Drop Down Boxes

  • Thread starter Thread starter Vasu
  • Start date Start date
V

Vasu

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
 
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.
 
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
 
In a cell adjacent to the material dropdown enter

=VLOOKUP(cellref,Table,2,FALSE)

Where cellref is your dropdown cell and Table is a named range of Material and
Price


Gord Dibben MS Excel MVP
 
I have changed the way I want my spread sheet to work, I would like for it to
display the type of material, then the material number, then the specific
type, and then the Cost. For exaple:

Material Code Type Cost
Vinyl 7045 3.2 ml matte white $0.0014503

where material and and the code are drop downs. I have gotten the Material
and Code drop downs to work however I have problems the type and Cost.
 
Are the code numbers for Vinyl unique to that material?

VLOOKUP formulas in C2 and D2 will return values from the code number.


Gord Dibben MS Excel MVP
 
Back
Top