Excel Data Validation - Lists

Question

This is in regards to using "List" in Data Validation.I am using a table and in a column of cells I call on list from this table. I am wanting to use another column to select from pre-defined set of 4 parameters, Based on what you choose in Column X, I want Column Y to pull a certain list. Is there way to have my list called in this manner? If not, what is the best method to pull data from the table using the method of selecting a parameter in Column X to view only options available in the list for Column Y.&nbsp;Example:Column X &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Column Y&nbsp;(options)&nbsp; I beam &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Brings up a selectable list of items in the table "beam"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; C channel &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Brings up a selectable list of items in the table "chnl"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; L angle &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Brings up a selectable list of items in the table "angle"

wyn hopkins · Answer

Hi&nbsp;cwaggoner
&nbsp;
I've written an article on this&nbsp; here&nbsp; &nbsp;https://accessanalytic.com.au/excel-dependent-drop-down-boxes/
&nbsp;
Let me know if that helps

Forum Discussion

Excel Data Validation - Lists

1 Reply

Resources