Drop Down Lists in Excel - Masterclass (incl. Dynamic, Dependent & Searchable Drop Down Lists)

welcome to this excel master class on drop down lists drop down lists are a powerful excel feature that allows people to pick an item from a list that you create they can be used in so many different ways within a spreadsheet and there are some amazing techniques that you should know in order to unleash the full potential of drop down lists in excel that's why i decided to put together this master class for you that covers all these techniques from the most fundamental to the most advanced with easy to follow examples i gonna start with the fundamentals of how to create a basic drop down list for data input after that we're gonna take a closer look at more advanced techniques so i'm gonna explain how to dynamically update a drop down list with new data and how to apply conditional formatting on static and even on dynamic drop down lists and then the second half of this master class covers the most advanced amazing techniques and applications like how to use a lookup function to dynamically extract data from a big data set based on one or multiple dropdown selections how to create multi-level drop-down lists with one drop-down list changing its items based on another drop-down selection and as the final cherry on top you will learn how to create a searchable dropdown list that automatically filters down the list items to the ones that contain the search term you have entered so this master class will hopefully add a totally new dimension to your excel skill set and expand the possibilities of what you can do whenever you work with data in excel speaking of data i want to tell you everything about the sponsor of today's video datacamp no matter what industry you are in analyzing and understanding data is more critical than ever before that's why datacam provides you with all the tools to learn the most important data science and analytics skills required to succeed in the real world with over 300 courses from over 250 expert instructors datacam provides plenty of efficient bite-sized lessons that will easily fit your schedule and can be accessed on any device i personally love the fact that they have immediate hands-on keyboard exercises so you can smoothly shift from learning into practicing a data cam subscription starts at only 25 per month and for that you get unlimited access to all of their courses and assessment tests but you guys can sign up with the link in the description to get the first chapter of any course you want for absolutely free thanks again to datacamp and now let's get started with this excel master class drop-down lists are often used for simple data input let's look at this list of projects we already have the project names and start dates entered now we want to assign a department to each project and set a project status we could manually type in the department name and project status but using a drop down list instead makes these inputs way easier makes it a way more pleasant user experience and most important it will ensure data consistency to insert a basic drop down list into a cell select the cell and go to the data tab in the data tools section click on the data validation button which opens a small window here we can choose between different data validation methods for the drop down list select list now there's a new input field that says source this is the place where you can define the items that will be in your drop-down list the most simple approach is to directly enter the items into this field separated by a comma once you're happy with your list just click ok and now you see this drop down arrow that allows you to open the drop down list and select an item that will be inserted into the cell you can change that item at any time by selecting another item from the drop-down list or if you want to delete the cell content just press the delete key on your keyboard now if you want to rename an item from the list with this simple dropdown setup you would have to re-open the data validation window and change the items within this source field this might be okay if you have not more than 5 list items that rarely change but for lists with many items or many changes you should go for a cleaner and more flexible approach instead of entering the items directly into the source field i recommend to define the list on a separate worksheet like i already did here and then simply reference the list item range using your mouse once you click ok all the items in the reference range can now be selected in your drop down list if you want to rename any of your items now it is much easier as you can just go to the other worksheet and change the item's name in the cell directly the changes will be automatically present in your drop-down list you can improve the user experience of a drop-down list by adding a helpful input instruction let's say project a has multiple departments involved and the user filling out this sheet is not sure which of these involved departments should be selected to cover that scenario you can add an input message that helps the user to make a selection for that just open the data validation window with the cell selected and in there go to the input message tab right at the top you can control the visibility of the input message and below that that's the place to enter your message let's set up a helpful instruction for the department drop down list and once we are ready we click ok now whenever the cell with a drop-down list is selected the input message will be displayed to make it easier for the user amazing adding a drop-down list option to your cell doesn't mean typing in values directly is not possible anymore you can still type in values just like in any other cell let's try to type in a department that is not on the list we get an instant error message because by default the data validation functionality of the drop-down list only allows values that have been defined as items in the list if you want to allow other values to be entered or want to customize this error message you can do that in the data validation options this time you need to go to the third tab that says error alert the checkbox on top allows you to activate or deactivate the data validation completely unchecking this box would mean you could enter any value without any validation or message popping up but if you want to allow other values but still have some sort of control mechanism you can change the style from stop to warning now when we try to enter sales again this time we get a warning message and now we can decide whether we want to continue or not so this is a less stricter form of data validation another alternative is the information style this will only bring up a notification that the value differs from the items on the list but no further questions asked for most use cases however i recommend to just leave the default stop style activated but something you can do in all scenarios is customizing this error message so instead of having this generic error text we can change that to something more useful like for example unknown department please select a department from the list and now if we enter sales we get this custom error message instead of that generic one pretty cool let's take a look at the status column this is another prime example of a data input field that you want to use a drop-down list for so that you know which statuses are available and more importantly that status labels are consistent so just to quickly recap how to do a simple and flexible drop down setup let's insert a drop-down list right into the cell first we go to the other worksheet and define the list items then we select a cell open the data validation window select list and reference the defined range of list items and that's it now that we have set up these two drop down lists for the first row let's talk about how to copy them to the other rows because we want to have the same drop down options there as well there are basically two ways to quickly copy the drop down functionality to these lower cells one way is to select the upper row and use the autocomplete function at the bottom right corner of the range to drag everything down that copies the drop down lists but also the content that we have already selected so with this method we would need to clear everything if the cells are non-empty but now we can just do the same selections as in the cells above for both the department and status column if you want to make completely sure that only the drop down functionality is copied to these other cells select the cells with the drop down lists press ctrl c and then select the rows below right click and click on paste special and in the opening window you have the option to select validation that way only the validation settings of the cells are copied down and everything works just fine now that we have multiple cells with the same drop down list stacked on top of each other there's one question left if we change the source reference for the drop down list in one cell how can we make sure that these changes are applied to all other cells that have the same drop down settings it's actually pretty easy just select one of the cells open the data validation window do whatever changes you want to do for example let's exclude these last two departments from the list and if we now hit ok these changes would only apply to this one cell instead we check this option which says apply these changes to all other cells with the same settings and you see all these similar cells are automatically detected and if we now click ok all department drop-down cells have an updated list of items amazing at this point we have covered all the fundamentals on drop-down lists in excel now we are ready to get you familiar with the more advanced techniques so let's go while for some drop down lists you never want to change any of the items there are lists that need to frequently undergo changes as items have to be removed or added let's take a look at this project task list as an example it already has some tasks in it and now we want to assign each task to a project member and set the task status again drop-down lists make a lot of sense here so let's insert the lists with the methods we know we open the data validation window select list and reference the range with all team members that we have set up in a separate worksheet and we do the same for the task status as the drop down cells are empty at the moment we can easily copy these drop-down settings down to the other rows and as you see the drop-down lists work perfectly in each row and column let's take a second to compare these two drop-down columns these status values will probably never change within the project duration so the way we have set it up with absolute cell references is perfectly fine for the team member column however it is probable that we need to make a lot of updates to this list of drop down items especially if this is a big project with team members coming and going for example let's say tina joins the team so we add her to the list on our back end if we try to find her in the drop down list she's not in there because we have set up this list with an absolute range reference that doesn't grow or shrink dynamically to solve this problem i will show you two amazing methods that you can use to make this range dynamic the first method is to transform the list into a table for that you can just press ctrl t let's quickly change the table layout and set the name to team table for the drop down list we open the data validation window and replace the absolute range reference with the table name well excel somehow doesn't accept the table name directly even though it detects the table correctly but to access the table items we need to put the table name inside the indirect function make sure to make the table name a text value by using quotation marks and of course don't forget to set the apply to other cells check mark and as you see the range has now dynamically updated and we finally can't select tina let's add another team member we're going to go for thomas here and he is instantly available as well pretty cool the only drawback that comes with this table method is if you remove team members at the bottom the table range doesn't shrink again so we have these ugly white spaces there and now we would have to manually resize the table range on the second worksheet that's why i want to show you a second method that i personally prefer for that second method at first let's convert the table back to a normal range the second method is based on the one and only excel function for dynamic ranges you've guessed it right i'm talking about the offset function if you want to learn more about that function in detail i got it linked for you in the description for our purpose here we only need to reference the first item in the list as the starting point of the range then we will skip the rows and calls parameter and then we define the height parameter as the number of non-empty cells going downwards starting at the first reference here we use the count a function and pass the potential range of items that we want to cover so right now we have seven non-empty cells in that potential range and thus the count a function will return the value 7 and the offset function takes that value 7 as a height and will return a dynamic array with all the list items starting at the first item and going down a height of 7. let's add another team member to show you as you see tina is now part of that dynamic array and other than the table range if we remove some of the bottom items the dynamic array shrinks again amazing we can enter that offset expression directly into the source input field in our data validation setup window let's confirm and now when we add a new team member the team member is instantly available and the other way around when we delete some of the team members on the second worksheet the list is dynamically reduced and we don't have any of these white spaces it's open to you to decide which of both methods you prefer but yeah i'm interested let me know in the comments conditional formatting allows you to beautifully highlight and visualize your drop-down items since you have an at least temporarily fixed set of items in your drop-down list you can easily assign colors to each individual item that will be displayed once you select it for a static list like we have here in this example with the status column it is pretty straightforward to set up conditional formatting rules because you can't just hard code these rules as you expect the items to not change over time so to show you let's set up some rules to better visualize the task status for example let's make the cell have a green fill when we select done as the task status at first we select the range with all drop down cells then in the home tab we click on conditional formatting and new rule this opens up this window where we can define the rule details let's use a formula to define a condition and if you define a condition for a range always use the first cell in the range as your reference cell and then make sure if your range goes over multiple rows to make the row reference a relative reference so no dollar sign in front of the 5 here if you do that this rule will then be active for all rows in that range to check if the item done has been selected just set the cell reference equal to the word done and in case this evaluates to be true we change the format of the cell to have a green fill and a white font click ok and now this rule is active for all drop down cells in the column let's set up a second rule for the in progress status we set the first cell in the range equal to in progress and then format the cell to have a grateful and white font that works perfectly and now we have three different fill colors for each individual status the setup for the static drop down list was so quick and easy because we just use the text values directly when we set up the rules if we want to set up something similar for a more dynamic column like these team members we have to go for a more flexible approach we cannot simply set up a rule for michael because michael might be gone by tomorrow and then we would have to change the rule manually to whomever takes his place so let's see how we can set up a dynamic conditional formatting that automatically assigns an individual color to each team member independently from the actual name as we don't want to get visually overwhelmed by all the colors on the screen let's add a new column right in front of the drop-down column and set up the conditional formatting there so each team member will have an individual small color code right in front of the name that means we're going to set up conditional formatting in a cell that is not the actual drop down cell but it will be based on that actual drop down cell to also add these colors in the backend worksheet we insert the same column there and one thing we should do when we set up a conditional formatting for a dynamic column we should set a limit to the number of items that we built this for technically you can create this dynamic color coding for as many items as you want but we're going to create it for up to 8 team members now again we start by selecting the range for which we want to add the conditional formatting and create a new rule be careful this time we're not going to use the first cell in the range but the drop down cell right next to the first cell in the range now that we don't exactly know what the exact value in there will be we're gonna set up the color coding not for a hard-coded text value like michael but we simply gonna reference the items in the second worksheet by their list position so this first rule will be true whenever the first item of the list is selected make sure that this reference is an absolute cell reference so you need dollar signs in front of both column and row then we select the color code for this first item in the list and one cool thing you can do is use your theme colors for your items because then you have the opportunity to easily change the whole color code set with only a single click for the first list item we gotta select this color and then we gonna copy that expression so that we can reuse it as i said i will set up this dynamic color coding for up to eight list items so we have to add seven additional rules here i just gonna insert the first condition and increase the row number by one so this time the drop-down cells will be compared against the second item in our list and we set the format to the next color in the theme color set we just repeat that six more times each time referencing the next item in the list once we have set up all eight rules you can see we have a little issue here it seems like the last rule we have set up is somehow active for all the empty cells but we're going to fix that in a second just to show you that the color coding works for the list items let's select a few items and the color codes are displayed correctly now let's fix this default color issue for the empty cells because actually we want them to be empty if no item is selected the issue at the moment is that we don't have an item in the list on the second worksheet at position 8. so all empty cells on the first worksheet are equal to this empty position in our backend list to fix this we need to add one additional rule with this rule we simply check if the drop down cells are empty so if no item is selected we don't set any format for this one we just insert it this additional rule is added on top of all other rules in our conditional formatting rule manager you have to know that these rules are tested and applied from top to bottom so if we set this stop if true checkbox to active this first rule basically stops the other rules from being applied if we have no item selected pretty helpful to know that now all mtt member drop down cells have no color code displayed and that's how it should be with this setup now it doesn't matter how many of the eight potential items we have defined on the second worksheet and what their exact value is if we only have two team members the color codes are displayed for these two if we add three additional team members they automatically have their own color code assigned which is pretty amazing as the last part of this dynamic conditional formatting i recommend to also color code the list items on the second worksheet so that you immediately know the color code for all defined list items the simple way would be to just fill each cell with the respective color like this first color second color and so on the only drawback here is the colors would be displayed even if there is no item at that position well i don't know how you feel about this but i personally prefer to make this color coding dynamic as well in a sense that the color for each item is fixed but will only be displayed if a team member is entered on that list position to make this happen we have to set up a similar conditional formatting but this time we need to set up one rule for each individual cell the condition this time is if this cell is not empty then set the fill to the respective color we basically repeat that for the other potential list items and at the end we have eight cells each one with its own conditional formatting rule and the amazing result looks like this now we can define the list items here each item automatically gets its own individual color assigned while the empty positions have no color and in the front end we can select all defined items and their respective color codes are automatically displayed this dynamic color coding technique is definitely something that will upgrade and improve the user experience on your worksheet yeah i admit it's a bit of effort but i think the result is definitely worth it in this case far we have used drop-down lists only for data input but you can also use them for extracting insights from a given data set and for example building reports or quickly getting specific information a very powerful technique for this is the combination of drop-down lists and the vlookup function to get you familiar with the concept let's start with a simple example let's say we want to be able to quickly get supplier information based on a supplier id we have a big data set with supplier data and what is really crucial here the supplier id column is our primary key column that means it only has unique values and with each of these ids we can uniquely identify the relevant name division and city information in the data set now to make our information lookup worksheet really user friendly we add a drop down list to this cell which has all the available supply ids covered we reference the supplier id column in the supplier data set and to allow more suppliers to be added in the future we use the offset formula that i have introduced earlier with this drop-down list we have all available supplier ids listed and now we can easily select the one we are interested in within a second to display the relevant information based on the selected supply id let's insert the vlookup function as the lookup value just reference this dropped out cell the table array is just a whole data set and we're going to add some additional potential rows as buffer for new data the column index for the name is 2 and as the last parameter we select false to get an exact match right now this returns an n a error which is no surprise as we have no lookup supplier id selected now if we have nothing selected this n a arrow doesn't really look pretty we want to have something more useful as an alternative output value here so let's use the if and a function with this function you can define an alternative return value every time vlookup returns an n a error here we just return no data in that case for the other two values to be extracted let's just copy this formula paste it and simply change the column index the division column is the third column in the data set and the city is the last column in the data set and that's the setup for this simple example case now we can use the supplier id drop-down list to quickly extract custom information from the supplier data set pretty amazing but to be frank with you that was easy because we had our data set up with an id and we directly use that id to extract information but what if the rows in our data don't have a unique id and no other single column with unique values this is when you can make use of multiple drop-down lists to extract specific information from your data let's take a look at this revenue and profit data set for each year and each division we have a revenue profit and profit margin value and obviously the year and division column are the lookup columns but notice that none of both has purely unique values in the year column the year appears multiple times and the same applies for the division column but we still have a potential primary key in here and that is the year and division combined because for each year division combination there is only one single row in that data set the only issue is vlookup cannot have two columns as lookup columns so the way to work around this is to add an artificial composed lookup column right in front of the other two columns let's move the data set one column to the right and create a composed key column here and the compose key value is simply the year and division value concatenated as a text let's just add this formula for all rows and now we have the lookup column we need even though we now have that one column in our data with unique values it wouldn't make much sense from a user experience perspective to directly create one drop-down list off of this column we still want to have two drop-down lists one to select the year and another one for the division the big problem is if we reference the year or division column as our drop down list source reference we have each item multiple times in there but we only want to have unique values in the drop down list for that exact reason we need to prepare the list items on a separate sheet you could enter them manually but if you want to automatically extract all unique values from your data you can do that easily in the latest excel versions with the unique function this function is a dynamic array function that returns all unique values of a given range as the range we insert the year column from the data as a dynamic range using the offset function this way we guarantee that all years are extracted even if new rows are added to the original data set there we have all unique gear values listed and then we can reuse this formula just change the column from c to d to extract the unique divisions beautiful we are now ready to set up the drop down lists usually to grab our prepared list dynamically we would again use the offset function but here we can take advantage of the fact that our prepared list already is a dynamic array because now you can simply reference the first cell and this is the cell that actually has the dynamic array formula in it and then add a hash symbol to grab all dynamically spilled values as you see that works perfectly let's do the same for the division drop down reference the first cell in the list add the hash symbol and click ok and that's how all these values are covered in the drop down list to extract the revenue and profit information we again insert the vlookup function wrapped inside the if and a function and now for the lookup value we need to compose the year and division value just like we already did in our data set so we use multiple lookup values combined to create the composed key for the table array let's reference the data set plus a little bit of buffer again the column index for revenue is four we want to have an exact match and the alternative error value is no data for the profit field we duplicate that formula and change the column index to 5 and for the profit margin the column index is 6. that's the whole setup let's test it at first we want to know the numbers for 2010 and the utility division that works perfectly just like all the other divisions as well let's also change the year and again all these specific numbers are perfectly extracted and presented to us pretty cool finally to test the flexibility of this whole setup let's add some new data to the data set to make it exciting let's add a new year and a completely new division let's go to the prepared lists and as you see both new values are automatically covered by these dynamic arrays and thus also available in the drop down lists and the revenue and profit data that we just added is also available without us doing anything that's the magic of combining drop down lists and vlookup of course this technique isn't limited to this lookup function only it can be used with any other lookup function or formula so feel free to test it out yourself multi-level dependent drop-down lists are another hot topic in excel the basic idea is to have one drop-down list items depending on what has been selected in another drop down list i want to explain the most straightforward technique on how to realize that let's look at this simple example we want to select a region first with one drop down list the regions are the column headers in our sample data and then based on which region has been selected we want to country dropped on this to only display countries of that selected region so if the selected region is asia we want the country drop down list to have these four items if it is europe we want to country drop down list to have these six items and the same for america the way we're going to do this is we start by naming each of these ranges we start with the headers and call it regions then we select the ranges with the respective countries and make the name equal to the region header so in this case asia this range is europe and that one is america to set up the region's drop-down list we now only have to set the source to equals regions and the drop down list displays all items of that range no big deal for the country drop down list however we cannot simply type in the name of a range directly because we don't know which of these three we actually want to have displayed to make this list depending on the other drop-down list selection we need to use the indirect function to interpret the value that has been selected here as a formula so if asia is the cell value here it will be interpreted as a formula and thus as the named range that we just defined for now this gives us an error value because we have nothing selected in the first drop-down list that's totally fine but as soon as we select asia this drop-down list has all the asian countries listed if we select europe now we can choose between all the european countries and the same applies for america this is how you can easily set up dependent drop-down lists but what if you want to make these country lists dynamic so that you can easily add new countries without manual adjustment unfortunately you cannot use the offset function this time to make the named range dynamic but we can still use the table method and just convert each of these ranges into a table then we call the tables tbl asia tbl europe and tbl america after that we open the name manager and assign the dynamic table columns to the single region names that we use within the indirect function of the country drop-down list you see it still refers to the exact range but now this range automatically increases with new entries at the moment america is selected so we have these five american countries listed let's add two other south american countries to the list and there they are let's add another asian country select asia with the regions drop down list and there we have that new country in asia automatically included the same of course also works for europe dependent drop-down lists are definitely a technique you should try out for yourself so let me know in the comments what you think about that technique we have arrived at the last part of this excel master class so let's talk about searchable drop down lists this is definitely among the coolest techniques with drop-down lists because with this technique you can type in a search term and filter down the drop-down list to only those items that contain this specific search term this filtered data area is where we prepare the dynamic list content that we then reference for the drop down list if you have office 365 you can create this really really fast with the filter function but for everyone else with an older excel version don't worry i won't let you down i will explain how to create the filter functions functionality with a little more complex but super smart workaround let's go the basic idea of the filter function is to filter down a given array of values by comparing it to one value like a search term in its simplest form the filter function requires you to reference an array then for the second argument which is called include set the search term equal to the array this will do a row-wise comparison and return a same sized array of true and false values and for the last argument simply enter a message to be displayed if no match is found the problem is this simple comparison only returns those rows that exactly match the search term so when we only type in the first name tyrese nothing is found we have to type in the full name to get a match for our drop down list however we want to return all items that have the search term at some position in the text so if we enter the first three characters tyr we want all items to be displayed that contain this little text part so let's start by building the formula we need from inside out we start with the search function with that function we can do a row-wise comparison of the search term and the items in the data set now this will give us a dynamic array which for each item has either the position index of the search term in the text or it gives us an error value if the search term hasn't been found if we only search for y there are a lot more rows with numbers the second item for example has the letter y at the third position if we now take this expression and put it inside the isnumber function we will get a true value for each row that has the search term in it and all other rows are false and this is all we need for our filter function because the second argument which is called include requires an array of that exact form the filter function now returns a dynamic array that contains all items with the search term in them and that is all we need to set up a drop-down list and as you might remember from the unique function which also is a dynamic array function we can simply reference the first cell with the filter function in it and get all the other values of that dynamic array by using the hash symbol now when we type in a search term this error message comes up which is actually no surprise as we still have data validation fully activated this particular use case is one of the rare cases in which it makes absolutely sense to turn off data validation completely to temporarily allow search terms to be entered that are not exactly in the list so let's open the data validation window again and turn the error message off now if we type in a search term it is absolutely no problem no error message and the drop-down list is automatically filtered down to only those items that contain that specific term it just works perfectly amazing i think this technique can bring a lot of value to your worksheets that's why we should definitely take a closer look on how to implement this for the older excel versions as well so let's get right into it those of you with an older excel version have to go through a few more steps i'm sorry but that's how it is we have to somehow replicate what the filter function does what we can reuse from this expression is this part that tells us if the search term is part of a text or not let's copy that and insert it right into the separate column this time we're not going to search the whole array at once but only the item in this row we want to use this formula in all cells of this column so we have to make the search cell an absolute cell reference with dollar signs let's add this formula to all rows and right now it displays true for all rows because we have no search term entered yet but as soon as we enter something it displays true only for a few rows now we're going to take that expression and wrap it inside an if function and if that expression is true we want to return and this might be not super intuitive right now but makes sense in a second the maximum of the range d4 to d4 right now this might look a bit odd to you but we make the first d4 reference an absolute cell reference and for the second d4 we make the row relative so if we drag this formula down and add it to the other rows the range will always be going from d4 to the cell that is right above the cell containing the formula we not only compute this max value but also increment it by one and if this first expression is false we just want to return a zero let's update all rows with this new formula and now you see this formula basically indexed all the items that contain the search term every time the search term is part of the item text we look at the highest value so far and add one to that bryson is the first employee to have br in its name so the max value is zero and we add one to get one then for all these without br in their names we just return a zero and then broderick is the second guy that has br in its name the max value in the range above his row is 1 so the formula returns 2 and so on and so on if we change the search term just to a a lot more values are indexed now and comparing to the filter formula output we see that the indexed values are exactly the one also returned by the filter formula so it seems to work now we only need to find a smart way to list all these indexed items right below each other and ignore all the remaining items let me start by introducing the rows function which returns the number of rows in a given range we pass a range starting with the first cell as a fixed anchor and ending at the cell of the formula so if we drag this down it will just give us a series of 1 2 3 4 and so on and we gonna use that formula inside the vlookup function because we want to look up the index 1 in the first row the index 2 in the second row and so on we pass this whole array as lookup table and define the column index as 2 and then we set it to exact match now let's update all rows in this column with this formula and you see the row wise output is now the same as for the filter function amazing the only issue is if the index cannot be found the function returns a n a error but as we already know we can easily catch this with the if n a function and return an empty string value as an alternative from a visual standpoint the output is now exactly the same there is still a significant difference because the left output is a dynamic array and can be easily referenced while the write output is not dynamic yet so when we now open the data validation window again we cannot simply use the first cell plus hash symbol reference but we need to make use of the offset formula again only this time instead of using count a we need to use the count if function because count a counts the empty string cells as not completely empty cells since there is no actual character in these cells we can use the countif function to count the cells that have at least one character in them by putting in this wildcard expression as search term the question mark stands for any one character and the star means zero or more characters so both together are a wild card for one or more characters let's click ok and check if everything works correctly and as you see the searchable drop down list has the exact same behavior as the one with the filter function that's simply great now every one of you no matter which excel version you have knows how to upgrade drop down cells in excel with this amazing feature we are at the end of this intense excel master class a perfect time to remind you to take a look at data camp and sign up for their free content using the link in the description i hope this excel training was an amazing learning experience for you and i'd be really happy about your feedback that being said i wish you a beautiful day and see you next time cheers

Channel: The Office Lab

Views: 216,316

Rating: 4.9601769 out of 5

Keywords: excel drop down lists, drop down lists in excel, dynamic drop down list in excel, searchable drop down list in excel, dependent drop down list in excel, free excel course, excel drop down lists conditional formatting, excel drop down list vlookup, excel drop down list, how to create drop down list in excel, multi level drop down list in excel, excel conditional formatting, excel drop down list basic, the office lab, excel drop down list guide, excel drop down list tutorial

Id: JTduguvrF34

Length: 55min 44sec (3344 seconds)

Published: Thu Oct 29 2020