Dropdown list determines list for next cell

[kdorning]

I am trying to set up a spreadsheet that will allows the user to select from a list of categories (Inventory Item Categories). When the category is selected, I would like it to determine the dropdown list for the next cell. This is for completing inventory counts. So if the user selects "Copier" from a list of categories (Laptop, Desktop, Cabinet, Fax machine, Camera, etc.) it would return a list of Copier Manufacturers and Models or Descriptions. I have already defined the lists, but I am not sure how to proceed with the next step.

Is this possible in Excel without using VB? I am not a programmer, so would like to keep it simple if possible. I am good with vlookup, etc.

Thanks for your help!

 

[jorismoerings]

Of course this can be done without VB.

You have the lists already generated, that's brings you already halfway to the solution. Take a look here : Excel Dependent Drop-down Lists - Easy Excel Tutorial

Is this what looking for?

Rgs,
Joris

 

[kdorning]

On first glance, it is EXACTLY what I am looking for!! Thank you!!