Hi guys, Welcome to the Advanced Video Search Engine, and you are watching How to Create Multiple Dependent Drop-Down Lists in Excel | Automatically Update with New Values. That video is uploaded by Jopa Excel at 2023-08-26T13:24:54-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [LY6xBaLkJVY]
| Name | How to Create Multiple Dependent Drop-Down Lists in Excel | Automatically Update with New Values |
| Video Uploader | Video From Jopa Excel |
| Upload Date | This Video Uploaded At 26-08-2023 20:24:54 |
| Video Discription | List Changes As Previous List | How To Make Dependent Drop Down List In Excel | Indirect Function In this Excel video tutorial, we will learn how to make a dependent drop-down list in Excel using the indirect function to help us the list changes according to the choice of the previous list, that is, we will have a main list and a secondary list from the choice of the option of the first list, the second list changes automatically, that is, we can create several lists depending on the choice of the previous list depending on the chosen option previously to make a dropdown list in Excel make a list of options a checkbox a list of values in Excel we can simply select the cells in the Excel worksheet where we want to apply this list of options and click on data and then on data validation and that's it just select the list option and write all the options you want to have in your list and just separate each option with a semicolon for example we have categories and subcategories under categories we have options for income and expenses. These are the main categories and for each of these options we have several more options to choose from. In terms of income, we have an overtime bonus salary and others, as for expenses, we have water, light, gas, food, etc. so if I choose the revenue option in the category, the subcategory list will refer to the chosen revenue option, but if I choose the expense option, the subcategory list, the second list, the secondary list will refer to the expense options If I choose option A, a list will appear, if I choose option B, another list will appear, and so on. That's what we're going to learn to do in this free Excel tutorial the formula that we will use in Excel is the indirect formula or we can still call it the indirect function in Excel we can use the indirect function to return all the cells all the information referring to a set of data a practical example is what we are going to do in this Excel walkthrough for example I have several lists to choose from and each of these lists is in a different table I have a revenue table and another expense table see the name of my tables are respectively income and expense this way, if I use the indirect function in Excel and use the revenue criterion, the result of the indirect function will be all the values in the table that correspond to the criteria used, that is, it will return to me all the revenue values, such as salary, extra hourly bonuses, etc. and vice versa. now with the indirect function we can use it within data validation in excel instead of creating a normal list in excel and separating each of the values by semicolons we will use the indirect function instead and our reference will be income or expense to fetch information from our tables #JopaExcel #Dashboard #Excel LY6xBaLkJVY |
| Category | Education |
| Tags | how to | how to excel | jopa excel | step by step | spreadsheet | function | formula | excel formula | ms excel | microsoft excel | excel function | option list | drop down list | excel list | list options | box options | excel dependent list | data validation |
