+ Reply to Thread
Results 1 to 6 of 6

No luck getting dependent dropdown list to work

  1. #1
    Registered User
    Join Date
    04-26-2022
    Location
    Regina, Canada
    MS-Off Ver
    Microsoft 3654 enterprise
    Posts
    2

    No luck getting dependent dropdown list to work

    Hi

    I have been playing around in Excel trying to create a bowling scoresheet.

    I have been trying to add dropdown list from which the users can select the correct options.
    I have been able to get the main drop down list to work but unable to create a dependent dropdown list
    from the main list.
    I have googled and tried different options but unable to get anything to work.

    I am trying to keep the main data entry page to only allow specific details to be entered.
    I then want all work and 3/4 or my formulas in other sheets so I can lock them down so the users
    can't accidently delete a formula.

    Anyways
    Currently I am working on getting the Team input info working.

    Sheet: GAME1 : Allows user to select a team name and then select bowlers on that team.
    Sheet: DDL1: Table with team name header and associated bowlers listed below.
    Sheet: Sheet1: Column A has a table with a header called Team List and under it is all the team names.
    Column C - L tables with Team name header and list of bowlers beneath each.


    I have been trying to use the INDIRECT function.



    Sorry new to this.
    Hope I added enough information and in the correct place.

    Thanks
    Attached Files Attached Files
    Last edited by wirld1; 04-26-2022 at 06:54 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: No luck getting dependent dropdown list to work

    Use:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    04-26-2022
    Location
    Regina, Canada
    MS-Off Ver
    Microsoft 3654 enterprise
    Posts
    2

    Re: No luck getting dependent dropdown list to work

    That worked thanks.

    Trying to understand the syntax.
    =INDIRECT AND B1 make sense.
    How did you come up with "T" and &

    Thanks

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,375

    Re: No luck getting dependent dropdown list to work

    Administrative Note:

    Members will tailor the solutions they offer to the version (NOT a release number like 3654) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: No luck getting dependent dropdown list to work

    Your teams are a, b, c, etc. So you select a team and get a single letter in cell B1. However, the Named Ranges for your teams are TA, TB, TC, etc. So, you need to concatenate the letter T with the contents of cell B1. Hence, "T"&B1 and =INDIRECT("T"&B1)

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: No luck getting dependent dropdown list to work

    Thanks for the rep.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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. Dependent Dropdown list through VBA
    By chintamani.avinash in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-20-2022, 04:42 AM
  2. Dependent Dropdown list
    By hEINSTEIN in forum Excel General
    Replies: 1
    Last Post: 03-24-2021, 08:55 AM
  3. [SOLVED] how drop down list be dependent with information show by selecting dropdown list?
    By noelcjf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2021, 07:36 PM
  4. Dependent Dropdown List
    By rjcjason in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-07-2018, 10:51 AM
  5. Replies: 1
    Last Post: 06-04-2018, 06:16 PM
  6. Dependent dropdown list
    By Spikyd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-15-2017, 08:09 AM
  7. Replies: 7
    Last Post: 11-21-2016, 04:40 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