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.

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

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.

Amazing, I love your instructions, very clear.

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.😀

This is soo cool. Thank you. Subscribed!

This help me a lot! Thank you!!

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.

This is super helpful. Thank you for sharing this.

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 !

This was so helpful and so easy. Thank you!

wow ... the <a href="#" class="seekto" data-time="60">1:00</a> time stamp is GOLD ... binge watching your videos on google sheets

Save my day. Thank you so much!

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

Awesome, thank you!

this is the best solution, thanks a lot!

This video is great!

The second part of the video is a magical thing only you know Hash, AWESOME WORK!

This is just what I need. Thank you.

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

Thanks..It helped me a lot

Super helpful!

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

This is really cool

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?

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.

Great tutorial. Thank you very much

Many Thanks, best video on the subject!

Damn. this is gold

Wow nice tutorial on drop downs. Thank Hash!

thanks This made my work so much easy...

Super helpful! thnx a million bro

Dude your a life save

This is amazing. Thank you for sharing. :)

Great way, very creative, thank you!

Thank you for this information 🎉

Very useful, Thank you.

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

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.

perfect!

Thank you very much

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.

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

Really helpful and good explanation. I subscribed your channel 😊

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

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 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 ?

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

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!❤

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.

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 :)

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

please in the future paste the formulas in the description

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 .

Awesome!

Great video, you are Super Smart :)

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

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.

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

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.

Amazing!

BEST

can you make this in MS-Excel except google sheet

Thanks

is it possible that we can copy the dropdown menu's of B2 and C2 shown at <a href="#" class="seekto" data-time="284">4:44</a> into another sheet and achieve the same outcome? please help.

Great video

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

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.

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.

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!!!

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!

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?

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..

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

YOU ARE PERFECT

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

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.

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

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

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

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

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? 🤷‍♂️

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

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.

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

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 there not a way to have multiple drop downs read from the same query formula?

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

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

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

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

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

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

i need this in microsoft excel

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