Excel Dependent Drop Down List with Tabular Data without Named Ranges

Life-saver to find this again. A whole lot of help it is, thanks.

THIS DOESNT WORK WHEN THE DATA VALIDATION IS MADE IN A TABLE, CAN U HELP

Hi @leilagharani . theres any video of dependent lists based on id columns instead of header columns? Meaning I got A columns with the id and b column (categoryid and category name) with the display text, and another table with the id and let's say productid and product name. that could be helpful. Thanks in advanced

What happen in case is whe create three level dropdown menu. Everything look ok but.... if same values in second column appears in two different values from first column?

Thank you ❤

Which means this does not work with named ranges (CTRL + T)?

1000 thumbs Up

Hi. Thanks. Is there a way to have a blank cell when you change to a new division? I noticed the last selection remains

Thank you for the video tutorial, i tried the approach but when we copy the formula to D6 , E6 shows the values filtered in E5 its not refreshing

Hi leila..my doubt is..assume that there are 5 categories of reasons viz. Financial, Statutory, Accounting, Documentation, Others. I created a dropdown list using these names. The first 4 names have their reasons (i.e.) if I click financial , in the adjacent cell I get the list of reasons related to "Financial"..i did this using "Indirect" function...the problem is when I click the last category ("Others")... I want to type my own reasons...but when I type in the adjacent cell Excel shows me error dialogue box...How to solve this issue? Please help me...I'm waiting for your response❤

How can I do this with multiple rows?

Could you please make a video showing, choosing from drop down list, Country then State, then District, then city. Selecting country should list only states (provinces) in that country only, like that, selecting province should show districts in that province only. Thanks very much for your videos.

This is working fine when Division is ordered one by one, But "Division" is Unorder or Shuffle, do you have any solution!?

Thank you for this, I have learnt something new. You got yourself a like and new subscriber

Great clear tutorial for what is a great spreadsheet design element. Might want to include a brief explanation on how to get around the Data Validation formula bar not recognizing Table and column names as in the comments below from German Vargas, Carla V and Rene Oldenhoff.

Hi... how do we replicate the same in Google Sheets??

Thanks a lot, it's amazing and so helpful. Brief and concise.

Please explain,
If division remain un-order list, then what should we do?

Excellent👍👍👍

thank uuuuuuuu

You save my life for 1000th time, keep it up with the great work! Love your content!

Thank you so much for the tutorials. Can I do this automatically in town, city, and country?

This is too good. Really helpful

I owe you 👌👌👌

Very good stuff! I'm stuck in the last part where we're inputting the function in the data validation. It keeps telling me that there's a problem wiht the formula, even though I get the list I want when pressing F9 (prior to data validation). Any thoughts?

Excel won’t let me copy formula into data validation list

Your voice is so cute

Leila please make video of this for every row. Love you

Exactly what I'm searching for. Thank you very mush, you are my Saviour!! Great work there, will share with my friends.

What if the Division are not entered serially? I mean if the list starts with productivity and then right after productivity game division entered and then productivity again and so on.

Thanks - very helpful

Thanks Leila. I see this is an aged video so not sure if I can comment to get help. I have a similar list but my requirement is, I need to be able to see the entire list. Ex.: If I select " Productivity", I want to see all Apps mapped under it. So and so forth for Game and Utility. What's the way?

works perfectly when the column A has consecutive values. The only thing I wonder is how to implement if division names aren't consecutive?

thanks thanks

Awesome, thanks, Leila.

Great Video! Now I have to figure out how to expand the same principle for more consecutive columns. My Programm has 4 consecutive dependent drop down lists referring to one big exercise database (Exercise category -> Subcategory -> Difficulty -> Exercise Name). For each Subcategory there is 4 Levels of difficulty (beginner, intermediate, advanced, expert), which are repeating accordingly throughout the whole range of this column. Any Ideas how to solve that without creating a hundreds of Range Names?

How do I do this with three or four columns rather than two? It would have a filtering effect so each column completed would reduce the option for the next column(s).

getting frustrated maybe you can help me...

I am trying to do, is use a current `(LIST) drop down, and fill in a cell beside it with correct fill in a number format,.

so I am trying is the following, have a drop down box to choose an item, and have the cell beside to fill in with number that is associated to the drop down box

When the Divisions are not in order, this does not work. Any idea how to address that issue?

Got the idea in this video. Very nicely explained, but what to do if I need to have the dependent dropdown list with unique values.

works perfectly well so far. The only thing i wonder is how to implement if division names aren't consecutive?

Hi Leila ,
I am working on something similar but my data and dropdown is in two different sheets of the same file . I am getting “source currently evaluvates to a error” msg.

Hi Leila! I love your videos and I have been learning a lot from them. I have a question. I have been trying to use the UNIQUE($A$4:$A$43,FALSE) formula to feed the Data Validation list but with no luck. I even created a Name with the formula but the Data Validation keeps giving the error "The Source currently evaluates to an error. Do you want to continue?"

What puzzles me is that I can use an INDEX() formula to feed the Data Validation list, but I cannot use UNIQUE() to accomplish the same. Is there a way to use the UNIQUE() formula to feed the Data Validation list? I appreciate your help.

Hi I have copied the formula exactly replace my own field and I keep getting an error that I have entered to many arguments for this function is have I missed something or is there a limit to the function, I know it is a couple of years since you posted this and excel may have changed in that time. I have 24 Suppliers and 97 products and just want the products for the selected supplier to show in the second drop down. Any guidance would be apricated at this stage