Drop down list with pricing

[Roy]

I am looking to have a list of products of different styles of the same thing
and from different manufactures. I would like to pick a product from about 4
drop down list. that if I would pick sink it would only have the sink styles
left in the next drop down marked styles and ect. with the end having the
price. thanks Roy

 

[Norman Jones]

Hi Roy,

See Debra Dalgleish at

Excel -- Data Validation -- _
Dependent Dropdowns from a Sorted List
http://www.contextures.com/xlDataVal13.html


See also xlDynamic at:

Dynamic Dependent Dropdowns
http://www.xldynamic.com/source/xld.Dropdowns.html