Data validation problem involving dynamic issuses and tables

Hi all!

I have a problem i hope you can help me with. I have 3 sheets (Material, Other and Pricelist). The price list is in a table style, which i want to use as a base for my validation list. The price list consists of 4 columns: type; product; unit; price. The reason for having it in a table is that if you add items to the list i automatically gets incorporated in the pricelist.

Right now there are only two types in the price list: Material and Other but there will be more types in the future.

I want in sheet Material or Other to in cell B2 or something choose the type (Material or Other) and depending on which type i choose it will affect the data validation in in the cells B11 to B30 (the products in the pricelist). I would like the data validation list just to have the products that goes with the type in the price list. I also want it to be dynamic so when you add something to the pricelist (now it is a table) it will reflect on the data validation. The price list is a table right now but i cant get it to work with the data validation list so the data validation just points to one range in the table and not the whole table. In other words when i choose Material in B2 the validation drop down list in B11 to B30 just will consists of the products regarding Material in the price list.

Hope i made my self understood, but i doubt it. I´m uploading the file and maybe the fog blows away.

Hope someone can help me!

Masun

Thanks,

Will look into that thread!

/Masun