MS Excel 2007:

I work in sales and I'd like to have an easy way to make the offer as I speak to the costumer.

My starting point is a price list, where Column A is category, B is product, C is placement and D is price.

What I'd like my worksheet to do is the following.

I'd have two roll down menus, let's say they are placed in A2 and B2. The first one is "Category". When selecting a category in the first roll down, the second roll down ("Product" will change based on the category selection. When a product is selected, cell C2 and D2 automatically fills inn the placement and price.

Is there any way to do this without having to re-write the whole price list?

-Marovic