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

See:

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


--
Gary''s Student - gsnu200794


"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

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

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

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

"Gary''s Student" wrote:

See:

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


--
Gary''s Student - gsnu200794


"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

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

On Tue, 15 Jul 2008 09:20:02 -0700, Vasu wrote:

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

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

On Wed, 16 Jul 2008 06:21:03 -0700, Vasu wrote:

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.