Dynamic Drop-Down Lists Based on Another Cell's Value

[emmanuelkatto]

Hello Community Members,

My name is Emmanuel Katto, and I’m reaching out to seek your expertise regarding a challenge I’m facing with Excel drop-down lists.
I have a workbook where I am trying to create dynamic drop-down lists based on the selection of another cell. For example:

1. Cell A1: Contains a category (e.g., "Fruits," "Vegetables").
2. Cell B1: Should provide a drop-down list of items that correspond to the selected category in A1.

• If "Fruits" is selected in A1, I want Cell B1 to list items like "Apple," "Banana," and "Orange."
• If "Vegetables" is selected, I want it to show "Carrot," "Broccoli," and "Spinach."

I’ve done some research and attempted to use the INDIRECT function along with named ranges. Here’s what I did:

1. Created a named range called "Fruits" that refers to the cells containing the fruit names.
2. Created another named range called "Vegetables."
3. In Cell B1, I set up Data Validation using a formula: =INDIRECT(A1)

Is the method I'm using correct to create dynamic drop-downs? If not, what adjustments should I make?

Please let me know.

Thanks in advance!
Emmanuel Katto

 

[RoryA]

Welcome to the forum.

Yes it is correct. Are you having problems with it?