+ Reply to Thread
Results 1 to 10 of 10

Dynamic Dropdown Based on Cell Value

  1. #1
    Registered User
    Join Date
    04-22-2009
    Location
    Boston
    MS-Off Ver
    Excel 2013
    Posts
    68

    Dynamic Dropdown Based on Cell Value

    Hello,

    I have searched web for Dynamic Dropdowns however those solutions don't apply to my scenario.

    In the attached workbook in Lookup sheet, I need to select a State for each Product as a drop-down list. The list of States should come from Source sheet.
    If I select a particular State, the corresponding cell in the same row and in City column should show cities as a drop-down list based on the State selected.

    Another constraint is that the States with blank value are ignored to show in the drop-down for City (and hence it won't be possible to select Singapore since corresponding blank state is not selected).
    Attached Files Attached Files

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    any
    Posts
    8,750

    Re: Dynamic Dropdown Based on Cell Value

    You forgot to update your profile about your real excel version. Attached file is not compatible with the excel version in your profile.

  3. #3
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    any
    Posts
    8,750

    Re: Dynamic Dropdown Based on Cell Value

    maybe it will help you a little

    Dependent Drop Down

  4. #4
    Registered User
    Join Date
    04-22-2009
    Location
    Boston
    MS-Off Ver
    Excel 2013
    Posts
    68

    Re: Dynamic Dropdown Based on Cell Value

    Quote Originally Posted by sandy666 View Post
    You forgot to update your profile about your real excel version. Attached file is not compatible with the excel version in your profile.
    Updated now

  5. #5
    Registered User
    Join Date
    04-22-2009
    Location
    Boston
    MS-Off Ver
    Excel 2013
    Posts
    68

    Re: Dynamic Dropdown Based on Cell Value

    !Invalid post. There is no option to delete.
    Last edited by kapilrakh; 07-03-2018 at 06:03 PM.

  6. #6
    Registered User
    Join Date
    04-22-2009
    Location
    Boston
    MS-Off Ver
    Excel 2013
    Posts
    68

    Re: Dynamic Dropdown Based on Cell Value

    Quote Originally Posted by sandy666 View Post
    maybe it will help you a little

    Dependent Drop Down
    Yes, came across this as well.
    It has list of Categories in a separate list. Mine has only two columns.

  7. #7
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    any
    Posts
    8,750

    Cool Re: Dynamic Dropdown Based on Cell Value

    is that what you want?

    defined Names
    INDIRECT() in the second DD

    Use Excel Tables to make it dynamic. Each list - Excel Table
    see first file to download from link in post #3
    Attached Files Attached Files
    Last edited by sandy666; 07-03-2018 at 06:27 PM.

  8. #8
    Registered User
    Join Date
    04-22-2009
    Location
    Boston
    MS-Off Ver
    Excel 2013
    Posts
    68

    Re: Dynamic Dropdown Based on Cell Value

    No, you have modified my source layout. I do not want direct modification of source since it gets updated from an external data source.

  9. #9
    Registered User
    Join Date
    04-22-2009
    Location
    Boston
    MS-Off Ver
    Excel 2013
    Posts
    68

    Re: Dynamic Dropdown Based on Cell Value

    If macro is a solution, then I can handle it. However I wanted to do this with Excel formulas. Please suggest.

  10. #10
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    any
    Posts
    8,750

    Re: Dynamic Dropdown Based on Cell Value

    If you want VBA ask moderator (using Report Post) to move this thread to VBA sub-forum.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Dynamic Graphing timeline based on 2 dropdown criteria
    By GuruWannaB in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-28-2018, 12:40 AM
  2. Dynamic Update of Trend Function Based on Dropdown List
    By Mathias25 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-17-2017, 07:14 PM
  3. Dynamic chart based on three dropdown menus.
    By Bjfgroot in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-30-2014, 03:43 AM
  4. [SOLVED] How to create a dynamic dropdown based on multiple lookup conditions
    By psilens in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-06-2014, 10:05 AM
  5. [SOLVED] Trying to create a dynamic dependant dropdown based on two-dimensional data
    By Caelen in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-26-2013, 04:53 PM
  6. Dynamic dropdown list selection based on combo box
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-10-2012, 10:55 AM
  7. Dynamic dropdown menu based on two criteria
    By Darsk in forum Excel General
    Replies: 5
    Last Post: 09-18-2011, 05:31 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1