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

Need dependent drop downs or cascading drop-downs in Excel? Use this simple but elegant approach.

This technique relies on the powerful & new XLOOKUP function.

Learn more:

[Jim-codv]

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.

[alvinazocar]

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

[GrainneDuggan_Excel]

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

[SharonShafiq]

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

[simonvaughan]

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

[faridqanet]

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

[aynino]

This is brilliant, thanks for sharing!

[grantm]

You have saved me, my precious Excel Guru!

THANK YOU!

[umairarshad]

Than you so much Chandoo. Love from Karachi Pakistan.

[tsbcoutinho]

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!

[RT-spcw]

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!

[Mathematica]

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

[arbazahmad]

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

[Hudtndklkzl]

Awesome video followed by awesome T Shirt :)

[_kc]

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

[johnborg]

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

[OzDesi]

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

[m.m.basetolimishkat]

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

[lakshmik]

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

[maruthiprasadsivapuram]

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