Hey All,

I want to create a drop down link that links 4 cells. I have four columns
one for material, then material code,the spesfic material name, and then
cost. I would like to link as such, first i choose my material (eg. Vinyl or
Polyester), this wil limit me to some material code, once i choose my
material code it will show me the name of material, and it will show me the
cost of in the next column

For exaple:
Material -- Code --------Name------------------------Cost
Vinyl ----- 7045 ---3.2 ml matte white --------$0.0014503

I have gotten the Material and Code drop downs to work however I have
problems with getting the Name and Cost.

Can someone please tell me if this is possible and if so how?

Thank You
Vasu Sharma