Dependent drop down lists

[ashley.phillips]

Hi All,

I'm having difficulty getting these drop downs to function correctly. I have a list of item numbers ( a list that will be added to frequently) and corresponding colors the item comes in. I assume that means I need to put that specific data into a table to allow it to be able to be included in a dynamic lookup? what I am trying to do on the "request Sheet" tab, is create a searchable lookup of item numbers in column A, and have a dependent drop down list in column B to only bring in the colors that are associated with whichever item number is selected in column A.

Also note, trying to do this without VBA

Thanks for the help!

[menem]

(Sorry about my English).

Can you sort ITEMID & Color everytime you add more ?
If yes , please try this.

Regards.