Custom drop downs based on other dropdowns

I've got a spreadsheet with drop downs in columns from left to right for Product Type, Course, and Product. What I want to do is when a specific Product Type is chosen from a drop down list, the list of Courses should only pertain to the Product Type. Then, when a Course is chosen, the Product list should only be those products under the chosen Product Type and Course. Right now, all Courses and Products show up in the drop down list, which would cause the user to possibly choose a product that is not under the Product Type or Course.

Any help is greatly appreciated.

TJ

You will need to setup named ranges. You'll need a named range for your Product Types, then for each of your sets of courses. When you name the ranges for the courses, use the names that appear in the Product Type list. Once you have set up your named ranges then you can create your first dropdown using Data Validation > Choose Allow: List > Source: what you named the range for your Product Types. Then your second dropdown will also be a list but the source will be =INDIRECT($A$1) $A$1 will be replaced with the cell that your first dropdown box is in.