Help With Linking Drop Down Boxes

[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

 

[Gary''s Student]

See:

http://www.contextures.com/xlDataVal02.html

 

[John C]

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.

 

[Vasu]

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

 

[Vasu]

When I try to implment the price it doesn't work.
Thank You

 

[Gord Dibben]

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

 

[Vasu]

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.

 

[Gord Dibben]

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