Make Multiple Dependent Dropdown Lists in Excel (Easiest Method)

Подписаться 523 тыс.

Просмотров 33 тыс.

50% 1

Easily Create Multiple dependend dropdown lists in Excel.
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
In this video you'll learn how to create multiple dependent dropdown lists in Excel. This will include an XLOOKUP and data validation. Once this is clear, we'll also use the autopopulate feature that will change depending on your dropdown answers. We'll do this by combining the TRANSPOSE funcion with the XLOOKUP. FInally, we'll create an error check so the dropdown choices make sense. For example, if you select Europe as the region, it should only allow you to select European countries. For this we'll use the COUNTIFS and the XLOOKUP to make an error check, alongside a conditinal formatting to make it stand out.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Single Dependent Dropdown
3:38 - Multiple Dependent Dropdowns
5:50 - Autopopulate Dropdown Results
7:51 - Bonus: Error Check for Dropdown Choice

Опубликовано:

15 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 49

@KenjiExplains 27 дней назад

🔥Check out our courses here: www.careerprinciples.com/all-courses

@musamaiza6259 24 дня назад

Your videos makes excel easier for me. Thanks kenji

@Dmytro848 26 дней назад

Very useful as always, thank you!

@alexrosen8762 25 дней назад

Excellent tutorial 👌

@putrakamangpu5033 24 дня назад

Thank you for the very useful knowledge🙏🙏

@Luciano_mp 27 дней назад

Very good Kenji. Thank you!

@KenjiExplains 26 дней назад

Thank you!!!

@vsrkvaraprasadraju4900 20 дней назад

I'm Becoming Pro by learning through your videos 👍

@Asma-ep9bx 24 дня назад

Awesome 👌 thank you very much

@mahmoudmohsen8105 27 дней назад

very informative and simple. Thanks!

@KenjiExplains 26 дней назад

Glad it was helpful!

@camlex6310 24 дня назад

Great video!!

@claytonlee839 27 дней назад

kenji the goat!

@KenjiExplains 27 дней назад

Thank you!

@ianchandley 27 дней назад

What you said!!! I’m just learning about the AMAZING power of Excel, 30+ years after I first learned Lotus123….. These RU-vid videos are a treasure.

@Iriponpal 27 дней назад

I have learned alot from your videos ❤

@KenjiExplains 27 дней назад

That's awesome to hear thank you!

@michele_alioto 6 дней назад

by far, this is actually the easiest and fastest way.

@danielhartjes2479 10 дней назад

Nice job!

@alamiralshafay 27 дней назад

Great Lecture I like It. Thank you

@KenjiExplains 26 дней назад

Glad you liked it!

@user-sl9tg2ee3u 27 дней назад

Thank You Kenji

@KenjiExplains 26 дней назад

Thanks you for watching :)

@Abdullah_Alhathloul 18 дней назад

Very useful

@mohammadalbizri2013 26 дней назад

Wonderful

@willzinner8813 27 дней назад

interesting trick thank you

@KenjiExplains 27 дней назад

Cheers!

@unwanamiracle4341 27 дней назад

Thank you 😊

@KenjiExplains 26 дней назад

You're welcome 😊

@abubakarrk.conteh325 26 дней назад

Wow , super cool idea 👍👍👍

@KenjiExplains 26 дней назад

Thank you!

@abdulhamidalhaddadi2255 27 дней назад

thank you its working good.

@KenjiExplains 26 дней назад

Awesome!

@m.m.basetolimishkat5846 16 дней назад

Hello Kenji. 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 Region and the second spin button will spin only those Countries of a Region selected by first spin. Thanks

@colewest2259 27 дней назад

How would you do a dropdown but with different formulas ?

@chidinduuwaeziozi7360 26 дней назад

We could use a custom data validation formula to ensure the right list is always shown instead of simply marking the wrong one

@EffigyOfAdam 3 дня назад

Doesn't work on 365. As soon as I get to the second Data Validation list it errors out "This entry leads to an error. Try entering different values to continue."

@ENDTIMEHOLINESSREVIVALMO-df3xx 22 дня назад

Hi iam using excel 2016 and always having trouble when making dropdowns instead of words in dropdown go down one by one but instead they are all in one place

@coastalb1 27 дней назад

Word of caution. I updated a file with validations for drop downs and used a transpose formula. The file is used by a team in 3 geographically different places, soon to be 4 and must be shared. The transpose formula “breaks” the validation in one column because it is a shared file. Will update it with one of your suggestions to select horizontal selection for the validation. Thanks!

@mayuronce 27 дней назад

India🇮🇳❤

@UtkarshKumar-mp2ls 27 дней назад

Like always 😂

@KenjiExplains 27 дней назад

Haha you're on fire! Thanks for supporting always :)

@MrNicho2011 23 дня назад

I have office 2016, =XLOOKUP(... ) isnt availlable, what can i do ?

@XavierSmithSchwazenegger 21 день назад

upgrade to 2021 or buy ms365 subscription

@BoooDave 16 дней назад

You’ll probably have to use index match. In older versions, that’s what was generally used when vlookup wasn’t good enough, so it was essentially the precursor to xlookup. Bit more complicated, but not too bad once you get used to it. Just google index match and you’ll find guides etc easily as it was common practice for a long time.

@sonicanic 15 дней назад

try indirect and create a name range for each row and refer to it. that worked for my usecace bc i dont need to add rows that often

@AbdulAbdul-bu4lr 21 день назад

Why must we download a file to practice? Why don't you teach us from scratch?

@KenjiExplains 21 день назад

It’s a free file so you don’t have to type all of the values manually as that’s very tedious. Just saving you some time

@user-gw1bq7ff4o 25 дней назад

I have a question Kenji. Is there any such formula which can automatically separate the amounts of multiple items in one order id in the total amount column? Order ID Product Qty Product Price Payment Mode Cash Amount Card Amount Total Amount 20240520213102 1 995 Card 0 8500 8500 20240520213102 1 799 Card 0 8500 8500 20240520213102 1 6795 Card 0 8500 8500