Jun 19 2020 02:22 AM
I would like to create a drop down list with multiple words
Jun 19 2020 03:55 AM
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
Jun 19 2020 04:02 AM
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
Jun 19 2020 07:34 AM
Jun 22 2020 06:18 AM
Jun 22 2020 08:09 AM
Jul 13 2020 03:42 PM
@LA_Mitche11 Were you able to make a dependent drop down? If so could you share the steps. I think I have tried the same steps you mentioned.
Jul 13 2020 06:47 PM
I'm attaching a method of what I called "cascading" drop down or data validation lists. This simple demo is just based on first and last names....you can add combinations of first and last names to test the process. When you do, you'll notice that
This method makes use of the new Dynamic Array functions, UNIQUE, FILTER in particular. I also employ SORT so that the lists are shown in alphabetical order. But if you don't have the most recent version of Excel, you will not be able to use those functions, and therefore this method will not work.