You guy is amazing. I have been searching for this one long since, and most of the videos are giving partial solutions. Your ones have a complete package. Thanks a lot

Dude. You saved my bacon. Just organised my school's swimming carnival. Easiest video to follow along with by far. Thanks for all the hard work you've put in.

I took on something much more complicated than I initially thought as an amateur, and you made it work amazingly for me. I will be constantly adding to the sheet I was working on to make it better, but this was an amazing start. Thank you so very much.

You're the best person to use an define humanitarian, for making a course like this free. thanks Boss. Watching from Nigeria.

I have watched so many videos and yours is the only one that made sense to me. Thank you so much!!!

This was truly amazing! This brought my spreadsheet to another level.😀

Thank you. I've been trying to do this for several hours and tried several tutorials but yours is the only one that has worked.

Amazing, I love your instructions, very clear.

This is super helpful. Thank you for sharing this.

This is soo cool. Thank you. Subscribed!

Thank you for this amazing explanation and video! :)

i've tried to do this for hours ....... thanks for this video ! not all heroes wear capes !

wow ... the 1:00 time stamp is GOLD ... binge watching your videos on google sheets

This was so helpful and so easy. Thank you!

This help me a lot! Thank you!!

Only one thing: YOU ARE A GENIUS . Thanks a lot

this is an amazing video and very helpful. in your video you populated only 2nd row, how about the suceeding row? what is Query script for the 2nd and suceeding row?

Interesting technique (the split etc). However, when you need multiple levels of dependent dropdown menus, you often don't have unique far right items. If you for example have 10 types of clothes x 10 models x 5 sizes x 5 colors = 2500 items, you still get a dropdown menu that is too long, of at least 250 items, when typing an attribute.

Save my day. Thank you so much!

Thank you for sharing this. I need this so much at work.

Awesome, thank you!

I use a very similar method for creating category structures for all kinds of applications. My method is a little more complex but gives me more flexibility for the kind of work I tend to do.

this is the best solution, thanks a lot!

Love it. My problem is solved. Thanks.👍👍

This video is great!

This is just what I need. Thank you.

Hi It's amazing. On top of this, may I know how if I need it to be apply on every single row by using with multiple user to chosse the drop down in the same time ?

super helpful, thanks! I'm curious if I can do this by grabbing data from another spread sheet

This is the best video for Dependent Drop downs in google sheets. Kudos!

Thank you so much for this. I had spent hours trying yo get it done in Excel😅. Do you know if there is a way to clear the values whenever you select a different item from the drop down list? Instead of having to do it manually. I would appreciate any feedback. Thank you again!❤

Thanks..It helped me a lot

Really helpful and good explanation. I subscribed your channel 😊

Great tutorial. Thank you very much

Great tutorial. Do you know of a way to create a drop down that only has options based on another cell in the same row. e.g. cell in column A has country filled in as text. Column b needs to be a drop down of cities only in that country. I'm trying to use this for ACC numbers showing up per patient for a physio in NZ. Great to see a fellow Kiwi on here too :)

Nice content, subscribed. I have some questions not sure you could help, is out of topic. I want to sum to value below cell but I want it to stop when it detected the empty cell and done sum up the value below the empty cell.

Super helpful!

This is really cool

Thank you very much Hash. Do you have a list of short cuts for special characters like the arrow you used with Alt 26

Wow nice tutorial on drop downs. Thank Hash!

Many Thanks, best video on the subject!

Dear Ali Thanks for sharing such valuable technic but i have a question since i am new to Google Sheets how would you select data from another sheet? I tried many times but i am getting error. If possible please share the way of doing it .

I have an excel document that is for cabinet company. I have six tabs within the workbook. The first is the workbook, which is essently the customer pricing page. They have many options on this page to order what they would like. First, they enter the quantity in column A. Then, they choose which "Cabinet Series" they want (EconComm, Contractor, Premium, EcoGreen, Closets). Then they select the "Door Design" they want (about 10 options), then they select the "Door material" they want (30 options), then based on the prior items selected they should be able to talk to column "E" which is the "Cabinet Type" that corresponds, the select the "Cabinet Configuration" which corresponds, then enter the "Width, Height, Depth" to give them their price. I would be grateful for any ideas. Thanks.

This is amazing. Thank you for sharing. :)

Great way, very creative, thank you!

Super helpful! thnx a million bro

thanks This made my work so much easy...

Damn. this is gold

This has been a much easier to follow guide for creating dependant drop downs. Dont suppose you have any insight into how I could do the following. I am essentially creating a quoting spreadsheet based off an existing catalogue which is in my sheets - so I am looking for sheets to fetch the price that relates to all three drop-downs being correct ie ( Code > Size > Colour ) the prices exist in the catalogue I just need it to pull the single price in once the drop downs are filled TIA if you have an idea of this - if not also not a problem

Thank you for this information 🎉

perfect!

Dude your a life save

Hello, I made a dropdown list dependent on another one. However, when I change the value of the first list, the selection in my second list stays on my old selection. How to solve this problem and make the second list automatically update or delete itself when the value of the first list is changed? I see that an invalid message appears in yours, how to display the invalidity?

Hi Hash, this video is very helpful. I have a question... My columns are dynamic, meaning that they could increase in the future. I would like to have all the column headers populated into a dropdown. Selecting a value from the dropdown, I want the rows in that column to be displayed in the adjacent cell. In simpler terms, let's say we have a sheet called Positions, that has columns: Position1, Position2, Position3,... They have rows such as Skill1, Skill2, Skill3, ... There is no limit to the Positions or the Skills, meaning, the table can increase bidirectionally. A1 has a dropdown to pick a Position. All the skills (rows) underneath this Position should be populated in B1:B. A3 has a 2nd dropdown to pick the 2nd Position. All the skills (rows) underneath the 2nd Position should be populated in B3:B. A8 has a 3rd dropdown to pick the 3rd Position, and so on... Dropdowns in column "A" can occur sporadic. Have you come across this situation and know the solution to it? Any help on this would be much appreciated.

LOL, Yekaterinburg)))) you did you pretty good!

Very useful, Thank you.

I had to give up Excel for Google Sheets for one simple feature. Searchable dropdowns. Excel is still clicking/scroll. Unreal.

Thank you very much

how can we do this if our data is in report format not tabular format?

Hi, good video, but it hasn't solved my challenge. Is there a way to scale the first method and make the same conditions for a multiple rows for both drop-downs? I have a category and subcategory of the products, and I need each cell to display the same values. The second method doesn't work in this case, unfortunately.

Great tutorial! But what if you had cities in the rows instead of columns. Like F2: China, G2: Beijing, H2: Shanghai etc; F3: Japan, G3: Tokio and so on. Would that be possible to make such drop-downs without reformatting the categories Thank you!

Great video! Is there a way to create multiple drop downs as you continue to each column? EX: I choose a "Parent asset" in column A dropdown list. It would then populate in column B, multiple drop downs for every child asset associated with chosen Parent asset in from column A. The Child assets in Column B are now Parent assets to multiple drop downs in column C.

Nice video. Is it possible to make it where you select a country FIRST and then continent automatically fills up? Kind of reverse but while still maintaining the same structure or order of dropdowns.

please in the future paste the formulas in the description

Your video is amazing! Congratulations for that!! But I need your help I already spent more than 3 hours trying to replicate this formula in a simple spreadsheet but seems like I’m not able to replicate the formula for other lines below, is that right? In your first exemple you use the B5 cell as reference, but when I’m try to use the drop-down on cell B3 the selection on C3 keeps being dependent on B2 instead of B3, could please help me?

Hello! Thanks for your video-very helpful! I got it to work perfectly, however, I have a list with various inputs (rows) and each row has a different, let’s say, “Country” and “City.” When copying the formula down, values in the “City” drop-down don’t change since the formula you suggest is referenced to whatever the value is in B2 which is, for all intents and purposes, fixed. How can you make the list so that this value automatically changes as you select other “Countries” as you go down your list? I hope the question makes sense. Thanks!!!

hey mate. Do you have a demo of how to do the first method, but by using data from another sheet within the same file?

Do you have advice for if the second drop down list is pulling more data than its supposed to. So for example, If I have Asia selected, and the 1st drop down list formula gives me Japan, china & Korea. (which is correct) But then the second drop down list for the cities once I select Japan is showing me Tokyo, Seoul, and Beijing. And not just Tokyo as it should be, in essence it's disregarding that I've selected one county. Any advice/ problem solving is appreciated!! I got it to work the first time but every other time I'm getting this glitch..

I loved it!!! It is exactly what I’ve been looking for in order to search on 7,000 items with 3 columns of dependents … And then I noticed it was NOT in excel. 🤦‍♂️ Is this doable in Excel or am I just S.O.L?🤢 What would you suggest? 🙏🙏🙏 Learn Sheets? 🤷‍♂️

can you make this in MS-Excel except google sheet

Great video, you are Super Smart :)

is it possible that we can copy the dropdown menu's of B2 and C2 shown at 4:44 into another sheet and achieve the same outcome? please help.

So I’m making a database for a wardrobe with about 1500 items. The drop downs help me out greatly and some of the clothing categories have sub categories. Do I need to make a separate query for each item? At that point I’d be better off typing it out. Everything in the subcategory is just going off the one query we did.

Is it possible to use a combination of multiple dependent dropdown lists and query function?

Many thanks for your video. I have a little problem in the front row it works fine but from row A3 onwards it doesn't work. Please give me the solution. Thank you

Hi, I've watched this so many times!! I just have a small problem, when I create the query, it only show me one of the names in column G. If I change the value in the first dorp down menu the query sometimes changes to the first word on G matching the one in F. Not all the time and it doesn't show me all the results it should.. I don't know if I made myself clear or if you can help me with this

This is good - I have 20 High Schools, 20 Middle Schools, 26 Elementary Schools Does the formatting of the columns change?

This is exactly what I need, but I need it for the High School, Middle Schools, Elementary Schls

Great work..... but how that 1st type of dependent dropdown work on the below let say 20 rows. I am unable to figure out kindly explain.

great video. Does anyone know how to reset the dependent drop-down list when the initial one is set to a different value?

Sadly, when accessing google tables from mobile phone, its not searching the row, only if you write starting with first letters of entire row

Awesome!

This is what I'm looking for, but there's something I need to add that sheet link to the Google form. Please advise.

hello. I want to extract data from a master list and have a sort criteria or filter for say one persons name from that list

why if I need this dynamic validation to all row? not only in 1 row?

this is a good solution for making endless lists, but i am looking for something that can run an sql that depends on the cell on the left

Amazing!

Is there not a way to have multiple drop downs read from the same query formula?

Great video

Thanks

Is this what you learned in college? I'm genuinely asking bc I dropped out and this seems really complicated.

My question is I followed all of your steps and I was able to successfully have functioning drop down list, but the little red arrow still shows in the cell and it states, "Invalid: Input must fall within specified range" but the list are correct, what am I missing, why is that still there and will it cause issues later if I keep it?

i need 2 dropdowns depending on 1 dropdown, for example i make 1 dropdown with iphone x, then next two dropdown should show depend on 1st dropdown

i needed just the first dropdown list but i have to make a dropdown query for each vertical dropdown list, Understand ?

BEST

I am trying to add if formulas in another coloumn based on city but am unable to capture the trigger city any ideas please

Is the second solution for multiple rows a dependant drop down , I dont think so...its only a workaround

What if I want to have multiple roles with these drop downs? I can't just drag because then it copies the previous one.

YOU ARE PERFECT

it has not asked me to autofill, resulting in only dropping down the top row. How do I fix this?

Help! Somebody! It is not working. Is it because I asked for the person name in the second column after the time stamp. I need those two. Should I move them and put the lists in the first three columns?