How to Create Multiple Dependent Drop-Down Lists in excel (Easiest Method)

learn how you can create multiple dependent data validation drop-down lists in excel. in which Each lists options are dependent upon the previous list selection. This is helpful to validate data entry. here i will show you the easiest method to make multiple and multi level dependent drop down lists using one xlookup formula. this is new and better way to create dependent dropdown lists in Microsoft excel. How to Create Multiple Dependent Drop-Down Lists in excel (Easiest Method) This requires the xlookup function, which is available in excel 2021, excel 2024 and Microsoft 365. Unfortunately, older versions of Excel don't currently support this. Note: XLOOKUP is not available in Excel 2016 and Excel 2019. However, you may come across a situation of using a workbook in Excel 2016 or Excel 2019 with the XLOOKUP function in it, if it was created by someone else using a newer version of Excel. Download Training File : https://bit.ly/3GuTakB Ai Tutorials ► https://bit.ly/4jTzsgX My Channels : A to Z Excel : https://bit.ly/3hQCRiw Deepak Techworld : https://bit.ly/3qFrbl5 Deepak EduWorld :https://bit.ly/3zWWtIS Deepak Nehra : https://bit.ly/364SVGV Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day. Deepak EduWorld Playlist's: Ai Tutorials ► https://bit.ly/4jTzsgX POWERPOINT COURSE ► https://youtu.be/OekrBhNybP0 ADVANCED EXCEL ► https://goo.gl/A6LdZA ADVANCED EXCEL FORMULAS ► https://goo.gl/bbHYu2 EXCEL TIPS & TRICKS ► https://goo.gl/wAj1jh MS WORD ► https://goo.gl/B4TeSA HTML5 & CSS3 ► https://goo.gl/2PFgs8 COMPUTER TECHNICAL videos ► https://goo.gl/paZmpn AUTOMATIC INVOICE IN EXCEL ► https://goo.gl/dFhg54 PHOTOSHOP ► https://youtu.be/m4KNkHwcV48 Subscribe Deepak EduWorld ► https://www.youtube.com/deepakeduworld Instagram ► https://www.instagram.com/deepakeduworld Facebook page ► https://www.facebook.com/deepakeduworld