Awesome Trick to Get Dependent Drop Downs in Excel (works for multiple rows too) 

I've been killing myself for 8 hours and 5 other videos...to the point of tears. I don't know how you pulled it off, but your method worked the first time I tried it. Superlative. Thank you.

Thanks a lot! An explanation in less than 10 minutes, how wonderful 🎉

Thanks so much - this is the simplest solution I have seen for this problem! Quite a lot easier to implement!

Such a cool feature! Thank you.

Incredible as always Chandoo, I didn't realise I needed this in my life until your video. Thank you!

You are amazing! I've been trying to do this all day!

Excellent, thanks Chandoo!

Thanks a lot, that is what I needed for my dashboard.

This is brilliant, thanks for sharing!

You have saved me, my precious Excel Guru! THANK YOU!

cool solution, thank you for sharing

Than you so much Chandoo. Love from Karachi Pakistan.

Awesome explanation. Thank you

Excellent chandoo

Thank you so much!!! Could you make a video explaining how to conditional format, in this situation? I didn't understand from the videos you have on conditional formating. Which formula to use in the rule of conditional formating? Because I have to relate the value to a list. I don't know how to do this. And the way yours shows the error, was awesome!

Excellent❤

Hi Chandoo, this is an awesome video - you make it clear and easy to follow. I have a question on the CF mentioned in the end though. I watched the video you recommended at the end but am still unclear how to implement the CF to highlight if the options in the drop-downs are mismatched. Grateful for yr advice!

Thank you Chandu😊

Excellent 🎉.. specially the Pushpa t-shirt.. Thanks for sharing 👍

Thanks a lot!

Fabulous!

Thank you ! Could you also provide the worksheet for practice?

Thank you.. thank you

Awesome video followed by awesome T Shirt :)

excellent t-shirt!

Could u share how u automatically highlight row with stale data?

new sub here, so cool!!! Thank you

Hello Chandoo. This is a very helpful video. I am wondering if can we use spin button from the developer tab instead of drop down list. For example: the first spin button will spin category and the second spin button will spin only those products of a category selected by first spin. Thanks

Thanks Chandoo. Can you make similar with named ranges and using the indirect function??

Amazing

Nice work, how to link prices of each items after the final selection?

Hi Chandoo, This is great. Is it possible to do this in google sheets?

Thank you so much, super helpful and so much easier than using the INDIRECT option. Is there a way to remove the blanks though in the drop-down for the second dependent list, that may not have have as many options as the others? (for example, Bars has a larger list than Bites, so how do we prevent the bites list to show so many blanks? I saw in your example that those "zeros' only resulted in one single blank, but for some reason mine results in many blanks). My list keeps defaulting to the blanks so unless you scroll up the user wouldnt see everything included in the dropdown list. Thanks!!

Like how we teach our kids A,B,C,D the same way he explains the concepts

Where in your other "Conditional Formatting" video do you discuss how to highlight STALE data?

Thank you for your video. Is there a way to remove the blank rows in the data validation?

Thanks

Can you do this without using xlookup function , are there any possibility to do this same thing using index match function?

Hey Chandoo, I'm a huge fan. Thank you for your consistently great content. I have a question, can i also use the old "Indirect" function to achieve this? Where in the validation, list, =Indirect(D5). Also the categories would have been made named ranges..Bars, Bites etc? Hope you can help 🙏🏿

Your t shirt is very good. Where you have bought??

it is applicable for the google form , can you share the link , it helpful me

Sir,please explain about semantic model

Content is as good as your t-shirt (taggede le😊)

Great Video , but how can we extend these to 4 levels or 5 Levels . Can you please let me know @chandoo

Can anyone help me understand on the last point on how to go with the conditional formatting. Couldn't find it out.

Dear Chandoo Sir… can you please make same kind of function idea for Microsoft 2019

Can it e done by hlookup in older versions of excel

Does it applicable to Google sheets as well?

Hi, typed in the data as above on a seperate sheet naming it DATA. Entering formula =xlookup(D5,data!$A$1:$E$1,data!$A$2:$E$12), but error tells me "VALUE NOT AVAILABLE .....". Any help troubleshooting this problem would be appreciate, many thanks

Can I get these values from a table like I get using filter command? I will explain better: I get a table with the collumns: category; product; product size. I can choose the category and show only the producs from that category in the next drop dow and in the othe next I only wanna show the sizes of that product. And this can follows how long desired.

Hello, is it possible that the Source in my List Data validation doesn't accept a fonction?

Do you have a video on this that does not use xlookup? So that it can be done w/o excel 365.

Where in your other "Conditional Formatting" video

Hello Chandoo please help me out here, I am trying to do this on google sheets, but I keep getting an invalid error response anytime I try entering the formula

Unrelated: I have a SQL question... I hope you can help out ... Inserting data into ms SQL server, theres an error response saying I can't insert more than 1000 rows... Please do you have a Syntax to help insert more than 1000 rows? Thanks.

Could you pls make the video for calendar drop down while entering date? If it is made earlier, plz share the link. Thanks

Can we use Index/Match if xlookup functionality is not available?

nice

What if the data is in separate Tab ?

Thanks Chandoo, If you expand the table, I don't think it will work. Or is that even possible? Already found, give the data a name.

Please make searchable dependent drop down list

🎉

"You may not use reference operators (such as unions, intersections and ranges) or array constants for Data Validation criteria" =N7:INDEX(N7:N35,LOOKUP(1,--(N7:N35""),N7:N35))

Haven't noticed pushpa till the end...😊

Unable to play the video

1000 likes🎉🎉🎉

Nice but this can be achieved easily using the Indirect function.

Ok, but what if I don't know what I want? Bars, Bites... All I know is that I want something with peanut butter, and I don't want to search through all of the categories.

First view

I am getting a warning --> this type of reference cannot be used in data validation formula😢

We can use indirect formula instead of xlookup😂

I tried a few other videos and got stuck. Thank ypu for explaining each step so clearly, I now have 3 level drop downs and it was so straightforward!🎉

Tried to create this xloopup function in browser but it says this entry leads to an error @chandoo