Comments on: Making a dependent (cascading) drop down list in Excel

The tutorial demonstrates how to create cascading drop down lists in Excel that display choices depending on the value selected in a previous dropdown. Continue reading →

Comments page 2. Total comments: 329

  1. Hi, This article really helped me out. However, I am still stuck in solving my problem.

    My drop down lists must be dynamic, because users may add or remove items on the list. It is not desirable to change the ranges on every update. That is why I am using a table.

    In A1 I have the first drop down list, in B1 I have the second, cascading drop down list. I got this working thanks to this article. Yeey!.

    However, I need to have the same values/conditions to work on the subsequent rows as well. Therefore I don't want to name every new cell on every new row. I tried to work with data validation. But that did not work out.

    Any help or ideas how to get this working for many rows instead of just one?

    Thanks

  2. Thanks
    It works and very benefit
    👌

  3. Hi
    Let suppose that I have Two Dropdown lists.
    A = Continent (Africa--America--Asia--Europa--Oceania)
    B = Country (Countries related to each continent)
    Both A and B dropdown list are multiple choice selected
    If in A dropdown list I select like 'Africa, Asia' , in B dropdown list, there's no possibility for me to use INDIRECT function on A to have Africa and Asia countries as filter.
    How can I solve this please.
    Best

    1. Hi! You can only use multiple selection in a drop-down list that does not have a dependent drop-down list. In your case, it is in drop-down list B.

  4. Trying to create a cascading drop-down list in my Excel spreadsheet.
    While the first drop-down list (category) works, the cascading part (sub-category) is not working. It's blank.
    Here's my set-up:
    On the first worksheet, I want to have a category drop-down list in column C (cells C4 thru C57). The column is titled "Select Category" (in cell C3).
    Column D would contain the sub-category based upon the selected category in column C
    On the second worksheet, I've entered all the categories and sub-categories as follows:
    Column A contains the names of the categories. I have entered the word Category in cell A1. Cells A2 thru A15 contain the various categories. Some categories are a single word; others are 2 words.
    Then in columns B thru O are the categories with cells B1 thru O1 having the same name as the categories in cells A2 thru A15.
    In columns B thru O - starting in the second row (cells B2 thru O2) are the sub categories. Some categories do not have sub-categories so the second row in that column is blank.
    I have followed the instructions in the tutorial, but it's not working. The sub-category (column D) is blank even though I select a category in column C.

    1. Unfortunately, I cannot create a drop-down list in your Excel spreadsheet for you. Perhaps you did not use named ranges as described in the instructions above.

  5. Hi all,

    My requirement is a bit different from what you describe here (or any other example I could find on the web).

    Essentially, I have a file with 3 columns:
    Child, Parent, Additional data.
    a, , ...
    b, a, ...
    c, a, ...
    d, b, ...

    So, b and c are a child of a. d is a child of b.

    My 1st dropdown picks a (as that is on the highest level). My 2nd dropdown list should show b and c (as they belong to a).
    The 3rd dropdown should show d if for the 2nd b was chosen. If c was chosen in the 2nd dropdown, the 3rd should have an empty list ( as c does not have children).

    Do you have any clever ideas how to solve this?

  6. Hello;
    I run into something I could not figure out.

    When I setup a dependent dropdown list with data validation in a TABLE, adding new rows to that table results in a data validation error in the primary dropdown in the row above when the dependent dropdown value in the row above has been filled!

    When you add a new row to that table when the dependent dropdown value in the row above has NOT been filled, it gives no error.

    WHY is that!
    WHAT causes the error or does not cause the error.
    I run out of ideas!

    The formulas that I use:

    Primary dropdown (C11) > =IF($D11="";lstRegions;"")
    Dependent dropdown (D11) > =IF($C11="";"";INDIRECT($C11))

    lstRegions is a defined name for the list of regions.

    PS: I can send an example workbook if needed.

  7. Hello, I'm trying to to create dynamic cascading drop-down lists in Excel using 2 levels. I've created the table "Families", the top row "L1_hierarchy", and want to place this onto a separate worksheet (same workbook) into cell $A2 (will fill downwards), which I call "L1_name".

    I then create the "L2_hierarchy" using the formula: "=INDEX(Families,,MATCH(L1_name,L1_hierarchy,0))"

    But when I try to create the cascaded drop down in cell $B2 (next to L1_name), which on the data validation is "=L2_hierarchy", the only drop down option I get is "L2_hierarchy" and not the specific cascaded drop-down list.

    Any ideas why?

    1. Hi!
      Unfortunately, without seeing your data it is difficult to give you any advice. You may find the practice workbook useful, which you can download from the link at the end of the article.

  8. is there a way for dependent dropdown list without a volatile function?

  9. Why does removing the $ to allow mixed cell reference not allow the second drop down to work? I edited your sample and it broke (named item fruit)

    Thanks
    Bill

  10. I'm getting confused on step 2.3

    "You create a new Excel name with this formula:" -- where/how do I do this?

  11. Thank you very much for this guide! It was comprehensive and enabled me to set up several dynamic dependent dropdowns.

  12. Hii..
    i have created dependent dropdown for 4 columns using OFFSET function, but problem is that i have same options in third column for all options in second column.

    example :

    male/female sam hobbies reading
    gym
    cricket
    passion cricketer
    Engineer

    john hobbies football
    swimming
    passion writter
    football player
    sofia hobbies singing
    reading
    passion singer

    for above example i have created dependent dropdown using OFFSET function but in 3rd when i select hobbies or passion it shows only hobbies or passion of sam due to same option names. so when i select john and then hobbies then it should show hobbies of john.

    please help me to solve that issue...

  13. I need to create a 3 level dynamic cascading dropdown list. My lists have multi-word entries with special characters and the lists contain a different number of options. I have followed the instructions and can get the first 2 working perfectly, but can't seem to add a third level. For this, I have created a second table, where the header is an exact replica of the second level and tried to reference the 2. I've named the cell in the second column (as in step 2.2), as a reference for the third cell, but all I get in the 3rd dropdown cell (when making an entry) is a blank option.

    I have the first 2 levels in one table (as header and table data) as suggested. I don't see how I can include a third level of options using this single table method. Should I create 3 separate tables and what are the steps for this method?

    Help!

    1. Hi!
      Unfortunately, without seeing your data it is difficult to give you any advice. For the third level of the drop-down list, you need to create a named range. Note that the range name must not contain special characters or spaces. Read more about named ranges in this article.

      1. I'm also looking for a 3rd level.

        My data is as follows:

        Plan Type -> Carrier -> Product

        For example:
        In the header row I have my plan types specified then in each column the carriers (and this is working for a 1 level dependency)
        A B C
        1 ACA Supp PDP
        2 Aetna ACE Aetna
        3 BCBS Cigna UHC

        So, if I select Supp; then I get the option for ACE and Cigna in the next dropdown and based on what I select there, for example, ACE, I would like to have the next dropdown have all of ACE's products (which would be different from Cigna's) and so on.

        Thanks for your help!

        1. I'm sorry for the double post - I should have been more specific - I'm using the dynamic cascading drop-down lists method from above and want to have a 3rd tier list based on the answer to the first two since there could be duplication of the company name in the 2nd section - so the unique value would be from the combination of the values in row 1 and the value in, for example, the ACA column. Thanks for any guidance you can provide. Also, the results in the 3rd drop-down would be multiple words with spaces and more than a single option.

          For example, if the first drop down is Supp and the 2nd would be Cigna then a selection for the 3rd drop-down could be any of the following:
          Plan A
          Plan B
          Plan C
          etc

          Or, the options for the 3rd drop-down might be:
          Basic health plan
          Medium health plan
          Super health plan
          Super duper health plan

          or something like that

  14. Good day

    I ram really stuck in trying to do a cascading dependent dropdown list. when using the Offset formula,
    1. "=OFFSET($AL$1,1,MATCH($Z3,$AL$1:$AV$1,0)-1,226,1)" this formula in the Data Validation for "List" resulted in it providing the correct drop-down but populating it to ALL the cells below. if I delete the result it also removes the functionality for the next corresponding drop-down selection.

    2. I the used the Name Manager (which I can't recall which one) and it worked, BUT when copying to dependent drop-down cells to the rest of the cells below, it still copied all the names down and if cleared, the functionality was gone too.

    3. I also tried to have the tables on a different sheet, but it did not allow it.

    At this stage I am so confused and do not know which way forward as I cannot even get the initial drop down to work again - or how to clear range names or Name Manager from the cells , which is probably the cause of the problem. I also could not find the page where I found the Offset formula.

    There is also INDIRECT but as I said nothing works.

    4. Name Manager: must it be workbook or list?

    5. I have used Name Manager to list all the content (2nd drop-down dependent on 1st column) under each Header (First drop-down)

    i. Name: (header and 1st drop-down selection)
    ii. Value: (the content under the Header/1st dropdown)
    iii. Refers to: The current Tab and the Cell range of the content)
    iv. Scope: tried both Workbook and list

    What I need:
    NQF Level (First column) Qualification (2nd Column dependent on 1st column selection)
    - NQF_L01 - Mathematical Literacy (AET4), or
    - NCert: Intro to Mining and Minerals

    - NQF_L10 - DscL Dotor Scientae Chemistry
    - Phd: Doctorate Phylosophy, etc,

    PLEASE guide me in the right direction as I need to make my tool available for use for the audit we are busy with.

    1. Hello!
      You can learn more about Excel names, named ranges and Name manager in this article on our blog.
      You may find the example files, links to which you can find at the end of this article, helpful.

  15. Thanks a lot very helpful... but not with figures. :)
    I want to create the same but with figures and percentages but it does not work. Is there any difference? Is it possible to do it in excel?
    Thanks

  16. Hi all,

    good article and very useful use case. However, I somehow could not replicate it in my MacBook, does excel for Mac has certain limitations in this regard.

  17. I am running into difficulties when referencing the source data which is on another sheet called Master
    list: This works with all the data on the same page: (my test page)
    =INDIRECT(ADDRESS(2, COLUMN($K$1) + MATCH(I2, $L$1#, 0), 4) & "#")

    But when I try and add the data validation to a cell on another tab in the workbook it doesn't work: (note Match(G6 has been updated as that is my new drop down cell)

    =INDIRECT("Master list"&ADDRESS(2, COLUMN($K$1) + MATCH(G6, 'Master list'!L1#, 0), 4) & "#")

    Can you see where I maybe going wrong ?

  18. Hi,

    I want to create a dropdown list with non-unique values. I have 2 groups of candidates, Group 1 and Group 2.

    So each candidate is assigned to either group, and I want to be able to select names from that group but it seems like the examples I've come across cater to unique, non-repetitive values?

  19. Is it possible to have a cascading list that will populate information that was provided last year, if no data last year a dropdown list is provided?

    I tried to complete this with a cascading list of a vlookup for last years data, however the vlookup does not compute. Is there a way to get the vlookup to compute?

  20. Is there such a thing as the database of information in the Table being too big? I cannot seem to make this work on a large scale, but I did make it work on a much smaller scale. Just wondering.

  21. Hi Svetlana / team,

    "Creating dynamic cascading drop-down lists in Excel" - you perfectly described my use case!
    I was researching for three weeks how to use extract a data validation range from one table, organized into dropdown 1 (=headers) and dropdown 2 (=individual columns). I have to admit while using Excel for two decades, i never was proficient enough for creating more than basic sheets.
    VLOOKUP, HLOOKUP, INDEX+MATCH, using helper cells for storing extracted range references... ewww.
    Thank you so much for sorting this out for me, really appreciated, have a remaining nice week!

    Btw, additional info you might think about adding:
    - Excel 365 / Excel Online absolutely want semicolons instead of commas in the published formula: =INDEX(exporters_tbl;;MATCH(fruit;fruit_list;0))
    And i have observed this requirement at many other places with formulas too. Not all, though.
    - Excel 365 online version does not show empty rows as values, Excel 365 desktop does

    1. Hello!

      The use of semicolons / commas in Excel formulas is controlled by the List Separator, set in your Regional Settings. Comma is the default list separator in North America and some other countries. In European countries, comma is reserved for the decimal symbol and the list separator is usually set to semicolon.

  22. Hello. I'm trying to create a drop-down list with the same selections across multiple columns. Per column, I'd like to hide the previous selections specific to individual columns. The issue I'm having is that if I select an entry in the first column, the entry is now hidden in every column, not just the first column. Any advice?

  23. Hello,
    I've read through this article quite a few times trying to apply it to my project here but keep running into errors. There may be just too much data to do this within excel but maybe I'm just missing some step. Hopefully someone here will be able to guide me in the right direction.

    I've created a database consisting of multiple worksheets where each one represents 1 Year (2000, 2001, 2002... etc.), all the way up to 2021. Within each sheet, a table resides consisting of the same 28 Coloumns with Headers representing Car Manufacturers (BMW, Mercedes.... etc.). In the Rows under each Column Header are the Car Models per that Year.

    From this, I'm trying to make 3 dynamic dependent drop-down lists (Year, Car, Model), where the last drop-down list (Model), would be dependent on both previous selections (Year, Car).

    Is there a way to create this drop-down list to include and pull the source data from all the worksheets? So that I have just 1 set of drop-down lists?

  24. Hi!

    So i need to create a dropdown list based on this condition

    Sheet 1 Column A, the range of list
    Sheet 1 Column B, approval is declared (per row)
    Sheet 2 D5, i need a drop down list where only the approved items on Sheet 1 Column A is listed.
    If it is not approved, it should not show on the list.

    What formula should i write on the data validation?
    Is this possible? Can anyone help me? Thanks in advance.

  25. Hello,
    Kindly help me to add two separate dropdown lists depends on a single dropdown list. For example, Both dropdown menu of State & Delivery time depends on the country dropdown menu.

    Country: State: Delivery time:
    1:India Mumbai 30days for India.
    Odisha
    Chennai

    2:USA Alaska 90days for the USA.
    California
    Florida

  26. Hi,
    Can I use the SUBSTITUTE function within INDEX & MATCH to create dynamic cascading muti-word dropdowns? I did not see an example of combining these two concepts (please let me know if it is there).
    Thanks!

  27. I have 2 Dropdown List with the same options (Included and Excluded) in different sheets. If I select " Included" in one dropdown list, it should also select "Included" on another dropdown list I need VBA code for this.

  28. Hi All,

    This was very helpful, but my data looks as shown below. The issue is I have to create the dropdown sourcing this sheet and not create a separate data sheet with unique values. Could you please advise how i go about this.

    Currently, I have created a separate data sheet with only unique values and sourced the data from there.
    here is the formula i have used:
    OFFSET('Data sheet'!$B$21,1,MATCH($E3,'Data sheet'!$B$21:$AN$21,0)-1,COUNTA(OFFSET('Data sheet'!$B$21,1,MATCH($E3,'Data sheet'!$B$21:$AN$21,0)-1,45,1)),1) . This works but i have to source it form main sheet and not data sheet...

    Country State City
    India Karnataka Bangalore
    India Karnataka Mysore
    India Karnataka Mangalore
    India Karnataka Davangere
    India TN Chennai
    India TN Ooty
    India TN Kanchi
    India TN Salem
    USA Florida Tallahassee
    USA Florida Tallahassee
    USA Florida Jacksonville
    USA Florida Orlando
    USA California Sacramento
    USA California Los Angeles
    USA California San Francisco

  29. When making the cascading dropdown lists, you cannot use special characters like / (slash) and even - (hyphen or minus) ! Something to note in the instructions.

  30. Hi,

    I was needing to find answer to my question on Data Validation Dynamic Drop-Down List+VLOOKUP. I hope you guys can help me achieve what I want to do.

    So I'll start off by describing what I would like to do. I have different sheets I would like to look up data on. I made normal data validation drop down lists for my PHASE, PURPOSE, & SPECs. I added a bit of a twist to the CATEGORY to where is only shows the amount of rows under the certain spec and there not be empty slots. All these work within the first two sheets which is fine.

    Now for the problem or solution I need to learn;

    I need it to work in the following manner; you select your SPEC, after that the CATEGORY column will display the categories under that SPEC, then your CHOICES column will display the choices under that SPEC+CATEGORY. So every SPEC has it own sheet within the workbook.

    I don't know how to make it work to where the CHOICES column displays whatever is in its corresponding sheet. BTW i only added about 15 SPECs its work in progress in case I had to go a different route.

    I would greatly appreciate any help on this and if I what I am wanting to do is not Dynamic Data Validation Drop Down List + VLOOKUP let me know or if there is an easier way I am all ears.

    Thanks,

    Bravo

    1. Hello!

      This is a complex solution that cannot be found with a single formula. Without seeing your data it is difficult to give you any advice. If you have a specific question about the operation of a function or formula, I will try to answer it.

  31. I am beginner in excel,
    I don't know whether my query will be solved through this method, but first i would like to ask for a solution to a problem that i am facing
    i want to create an excel sheet where in a column i just want to add the name of the content and the rate of that content should follow up along with it.
    in this manner i do not have to continually look up at the rates once i have put the content on it.
    It would be of great help if you could help me find a solution.

  32. Hello,
    I created the cascading drop-down list, but when I ask to show me the second dependent list, it shows me the (right) Header but not the list it contains. Please could you help me to find what's wrong with it ? I did follow your procedure step by step though.

    1. Hello!
      Unfortunately, without seeing your data it is difficult to give you any advice. Check if you have created a named range for each list.

  33. I created dynamic cascading drop-down lists but I'm not able to prevent changes in the primary drop down list using the following formula

    =IF(B2="", Fruit, INDIRECT("FakeList"))

    Is there a way to incorporate the above?

    1. Hi,
      Sorry, it's not quite clear what you are trying to achieve. Please describe your problem in more detail. It’ll help me understand it better and find a solution for you.

  34. Extremely useful. Thank you.

  35. Svetlana,

    Thanks for sharing this just in time!

    I am able to design my sheet!

  36. I am not that experienced with EXCEL. However I do use it to generate quick prototypes for business applications. I use these prototypes to help extract the detailed functional requirements for the users to feed into the design of the production business system application.

    One reoccuring feature is the requirement for a cascading drop down box.

    The first "Parent " drop down would be a parts list.
    This Parent list could have hundreds of entries for the user to select from.

    The second (child) Dropdown box contains the LOT Numbers for all of the products.

    Therefore the user first selects the Part Number using the Parent Drop Down BOX,

    Then the user will use the second drop down box to select the LOT NUmber.

    There are normally only 5 or 6 different LOT Numbers for each of the several hundred Part Numbers.

    It seems that the use of the EXCEL OFFSET, MATCH, and INDEX functions just cannot do the job.
    (But I am not an expert)

    What strategy should I follow to accomplish this.
    Trying not to use VBA Macros if possible.

    Thank you for any help
    Chuck

    1. Hello!
      Unfortunately, without seeing your data it is difficult to give you any advice. Please reread the article above, it covers your case completely. Thank you.

  37. Thank you! Finally someone with a solution to my problem!

  38. In data validation my source are digit ( numbers ) ,hence I get error message as "The source currently evaluates an error ",Do you want to continue ? .How to solve it . If the source is a text then it works fine ,but if it is a number it dosn't work.

    1. Hello!
      I’m sorry but your task is not entirely clear to me. For me to be able to help you better, please describe your task in more detail. Please specify what you were trying to find, what formula you used and what problem or error occurred. Give an example of the source data and the expected result.
      It’ll help me understand it better and find a solution for you. Thank you.

  39. I want nested dropdown list.
    Example:
    Fruit >Apple
    >Grapes
    >Mango
    Country >India
    >US

  40. Hi I would like to create a dependent dropdown list but my data is in this manner and its huge data. I only give 2 deps as example but there is a lot of deps. How can i make a drop down with this where my data in class is dependent on the dep.
    Example:
    DEPS CLASS
    SHOES KIDS
    SHOES KIDS
    SHOES KIDS
    SHOES MEN
    SHOES MEN
    SHOES WOMEN
    SHOES WOMEN
    CLOTHING UNISEX
    CLOTHING UNISEX
    CLOTHING UNISEX
    CLOTHING MEN
    CLOTHING MEN
    CLOTHING WOMEN
    CLOTHING WOMEN
    Thank you so much if you can help on this.

    1. Hello Mary!
      I can’t create a dependent drop-down list for you, because I can’t work with your data. I can only help with advice. But for this, ask a specific question - what is the problem, where the error occurs, which formula does not work.

  41. I have tried to follow the instructions above but am getting an error when I put in the formula for the second drop down(The Source currently evaluates to an error. Do you want to continue?) When I chose a selection in the master list, four out of five selections get no response, but one selection (the second option) then fills in the second drop down with options to choose from.

    What may I have overlooked or need to modify in order to get the drop downs to work? Your assistance is greatly appreciated.

    Thank You

    1. I am trying to create a dropdown with options that will then change the option in the second dropdown. I have five options in the first dropdown. I at first used the =INDIRECT($B$24) and then changed to =INDIRECT(B24) and finally have used =INDIRECT(SUBSTITUTE(B24," ","")) as my options in the first drop down have spaces. As I mentioned in the first comment, when I enter the formula for the second dropdown it gives me an error message, The Source currently evaluates to an error. Do you want to continue?, and I am unable to see four out of five of the options in the second dropdown. The second option, which I have as Inventory, will show in the second dropdown but not any of the rest. I am trying to have a person choose one of the options in the first dropdown, which will then give them a second list to choose options from. Such as with my Inventory, then gives the additional options of (Click to Select), Initiate Rental Agreement, Develop Inventory Management Plan, Create a Par Level, Create a sign-out sheet, Other. Right now the first dropdown is in cell B24 and the second dropdown is B35 on Sheet 1 and my list are on Sheet 2.

      1. Hello Lin!
        Here is what I could understand. You have the first drop-down list in cell B24. It consists of 5 positions. The second drop-down list is on the same sheet in cell B35. It works with the formula = INDIRECT($B$24).
        Next you need to create named ranges. Their names exactly match the values from the first drop-down list. This is described in detail in the manual above. Read it carefully. If you do not, then the second drop-down list will not work.
        Perhaps this is the cause of the problem.

        1. No sir, it does not work with any of the formulas. Currently only the second option in my first drop-down will bring anything up in the second drop-down. I currently have the formula =INDIRECT(SUBSTITUTE(B24," ","") as my first drop-down consist of Infection Control, Inventory, Procedure or Protocol, Site or Facility Need, Staffing Shortage. As for the named ranges, yes I have created the named ranges to match the names with the space changed to an _, such as for Infection Control the named range is Infection_Control or for Procedure or Protocol as Procedure_or_Protocol.

          1. Hello Lin!
            I do not see your data. Therefore, I can’t name the exact reason. However, remember that the names of your items from the drop-down list must exactly match the names of the named ranges. If the name is "Procedure or Protocol", and the named range is "Procedure_or_Protocol" - this is 100% not working.

            1. Good Evening Alexander. If I'm not mistaken a named range can't have spaces, so how do I make the items in the drop-down match exactly with the named ranges. I was of the understanding that the _ represented a space. How else can I make this work? Would it be better for me to send a copy to you to look at the data or is there another option? I appreciate your time and assistance with this matter.

              1. Hello Lin!
                Items in the drop-down list must contain _ instead of a space For instance, Procedure_or_Protocol. Your items from the drop-down list must exactly match the names of the named ranges.
                I hope this will help

    2. Hello Lin!
      I’m sorry but your task is not entirely clear to me.
      For me to be able to help you better, please describe your task in more detail. Please let me know in more detail what formula you used and what problem or error occurred. Give an example of the source data and the expected result. It’ll help me understand it better and find a solution for you. Thank you.

  42. Is it possible to create a dropdown menu that will automatically fill column A, B, C & D? Basically, I need to make one selection, and have the first four columns autofill.

  43. Thank you!!!! This was a blessing and helped so much!!!!!

  44. Nice article, but stuck. I have a drop down (master) that needs to change three other cells once you change the drop down.
    Ex. Historical list A_L, I_N, X_R, R_T
    Hours/tops 174, 47.2, 88.3, 13.2
    Metric Type Joy, Rain, Sun, Sad
    Source Joy.xls, Rain_GL.xls, Sun_2020.xls, Sad.doc
    If Historical List changes A_L to X_R
    The other need to go from A_L, 174, Joy, Joy.xls to X_R, 88.3, Sun,Sun_2020.xls

    I tried making the first Historical List the primary, and the others customer with a =if(B3=C7:C11,D77:D11,0) where B3 = Cell that changes from any given C7-C11 cells (array) and the D column hours/tops. I didn't continue because that didn't work. I tried various others ways, and I am just frustrated.

    1. Hello Kristy!
      I'm sorry, it is not very clear what result you want to get. Could you please describe your task in more detail and send us a small sample workbook with the source data and expected result to support@ablebits.com? Please shorten your tables to 10-20 rows/columns and include the link to your blog comment.

      We'll look into your task and try to help.

  45. Thanks Svetlana.. though this article was little bit tricky but i have enjoyed it..

  46. hi, is it possible to show 2 named ranges together using data validation. For example list A list of fruits and list B has list of vegetables. in dependent drop down list. we can get if A1 has fruits then List A, and if A1 has Vegetables then List B.
    But if A1 = c , i want to the list of both list A and list B, is it possible to do without creating named range including both list.

  47. A question already asked but I didn't find a response ...

    Is there a way to automatically update the exporter cell to the first item in the list once the fruit is selected?

  48. i have a problem that is difficult to explain but may well be very easy to solve, my biggest constraint in what i am trying to achieve is that macro is not allowed to be used as the template i am creating is uploaded into a platform that cant accept macros.
    Having said that, this is what i want to do: I am using a dependent dropdown list so when i select a particular cell in (column A) with a list, that selection informs another cell adjacent in Column B (another dropdown list) only certain value is available for selection list. I want now to complicate it further because i want to add another dropdown list in column C with a selection of A, B, C etc and hope that when i select A, B or C it will concatenate the data in column B cell. To explain it better, if i select Column A (fruit) Column B list would contain Apple, Pear, Plum, Orange but what if i want to identify the colour of the fruits i would have the colours available in Column C; red, blue, green and pink, so i want to have the option of adding the colours to the fruits in Column B cell.

  49. Thanks a lot! Great tutorial, especially for dynamic drop down!!

  50. Hello,
    I want to have a dependent list based on multiple selections from the first list. How do i make the second list only show values associated with the multiple values in the first?
    Example:
    1st list is "categories" and you can select multiple answers ("Arts, Business"). 2nd column would provide drop-downs for both "Arts, Business" ("design" (within "arts"), "investing"(within "business").
    Another example:
    List A
    A1 "X"
    A2 "X1"
    A3
    Multi-select A1 and A2
    Show values with X and X1 to multi-select.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)