Forum Discussion
Dependent drop down lists
I would like to create a drop down list with multiple words
Hi
Set up a list of words in a column on a separate sheet.
Then place the cursor on the cell that you want to create your drop down - and select Data Validation from the Data menu.
On the ALLOW option select LIST.
In the source select the range where your words are.
That is a basic method.
There are other things you can do to make it slicker but try that first.
Peter
Yeas I am fairly competent with that basic operation.
Having created that I would like to have the adjacent cell display a list of comments relating to that selected on its left.
have tried =index and =indirect
- Do you mean you want one drop list with (say) A B C and a second drop down which would have A1,A2,A3 if A is selected; then B1,B2,B3 if B I’d selected and do on?
