Results 1 to 2 of 2

Thread: Creating Dependent Dynamic List

  1. #1

    Creating Dependent Dynamic List

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear All,
    I want to create a dynamic dependent list. A test sheet is attached. In source table, each product category has different products against it.

    I made a list in Product table under product category. What I need is that when I select a category "A" in Product table, a list should appear in Product name (in Product table) corresponding to "A" in Source table and when I select "B", product name items corresponding to "B" shroud appear in the list, so on.....

    I believe that you can solve my problem very easily.

    Please see the attached sheet (DependentList) for reference.

    Thank you.
    Attached Files Attached Files

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Europe, Croatia
    Excel Version
    Excel 2013
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts