Conditional drop-down list

[swtbeb4lyfe43]

Hi all,

I need to make a conditional drop-down list that will show a different list depending on a value selected in another cell. For example:

On sheet 1 (titled "CC Input"), my Color Type is in cell A2: Green, Blue, Purple, etc.

On another sheet (titled "Drivers"), I have a dynamic list of values assigned to each color. Column A has Color type (Green, Blue, etc). Column B has Items (crayon, pen, paper, etc). I mean dynamic as in rows can be added or removed, but will always have a color associated in column A.

Back on "CC Input" sheet, if A2=Green, I want a dropdown in cell D1 that will pull the list of all values associated with Green from the "Drivers" worksheet.

Is this possible with named ranges & data validation? Thanks!

 

[meldoc]

Hello

See the link.

http://www.contextures.com/xlDataVal02.html

 

[swtbeb4lyfe43]

Hi,

Thanks for the reply. I've tried this using dynamic ranges for the supporting Named lists (using the OFFSET & COUNTA method), which are also on a different sheet (on the one titled "Drivers"), & it's not working. It just says there is an error when I try to enter the Validation List.

Is it possible to do this with what I'm trying to do?

 

[Jim Kuhn]

Try using the indirect function with your named ranges

 

[scottylad2]

http://www.youtube.com/user/ExcelIsFun#p/search/11/Los7Nb6Skdk

this video by regular poster mgirvin on you-tube will show you exactly what you need, adapted for your own needs of course.

 

[swtbeb4lyfe43]

amazing! it worked like a charm. thanks so much!