Multiple Dependent Drop-down list in Excel

Multiple Drop-down list in Ms Excel means that if you create a drop-down list then the other drop-down list will be dependent on the first drop-down list. Let's understand with the help of an example, I have different brands of Mobiles and their different models. So if I select any mobile from my first drop-down list then in second drop-down list which is of different Model of all the brands of Mobiles, I can see only the models of that particular mobile. If I select SAMSUNG in first drop-down list then in second drop-down list i will see only the models of SAMSUNG Mobile. Let's learn everything about Multiple dependent drop-down list in Excel step by step. Watch the video till the end to learn everything about Multiple dependent drop-down list in Ms Excel. We will learn step by step, how to create drop-down lists. Today we are going to learn 2 ways of creating Multiple dependent drop-down lists. It would be very helpful for you.  In first method, we will use three formulas i.e. Offset function, Match function, and Counta Function. While making drop-down lists, you can also learn how to use all these three formulas very easily.  Offset function Reference-The starting point,  from where you need to find cell reference or range. Rows- The number of rows to offset below the starting reference i.e. you want the answer from which row below your reference point. Column- The number of columns to offset to the right of the starting reference i.e. you want the answer from which column after the starting point. Height- [optional] The height of the rows. Width - [optional] The width in columns of the returned reference MATCH FUNCTION Lookup value - here, select that value or text which you need to find from a  particular table. Lookup array- It means  the array or the table from where you need to find your lookup value. COUNTA FUNCTION It calculates the  cells which are not empty. It means that cell should not be blank.  Cell can have anything like  text, numbers etc. Now, in second method we will use  INDIRECT FUNCTION. This function is used to create a reference that won't change even if you insert row or  column in Excel sheet. That particular reference would be fixed. Multiple dependent drop-down lists help you create your data in a unique way. Follow this link to get worksheet used in the video: https://drive.google.com/file/d/1Akoznt32ZtFrOqudPUndgx9bEiQifdv3/view?usp=sharing #learnxtra #Drop-downList #MultipleDependentDrop-downList Questions solved in the video- How to create multiple dependent drop-down list in excel Multiple dependent drop-down lists Drop-down list in excel Drop-down list Data Validation in excel Data Validation How to create list from data Validation in excel Offset function Match Function Indirect function Counta Function Formulas in excel Excel Learning excel shortcuts Excel functions ReplyForward