Results 1 to 6 of 6

Thread: Creat dropdown list with two columns

  1. #1
    New Member
    Join Date
    May 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Red face Creat dropdown list with two columns

    Hi All,

    I need a dropdown list with two columns
    Column 1 Codes and column 2 names
    Can you help me?

    Thanks a lot


  2. #2
    Board Regular
    Join Date
    Sep 2017
    Location
    Houston, TX
    Posts
    257
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Creat dropdown list with two columns

    Do you need the actual dropdown list to have two columns, one for codes and one for names?

    Or do you need a column in a sheet to have a drop down list for Codes and a different column in the same sheet to have a drop down list for names?

    -Spydey

  3. #3
    New Member
    Join Date
    May 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Creat dropdown list with two columns

    I need the actual dropdown list to have two columns, one for codes and one for names in one cell. example cell D1
    when the dropdown list open, two columns are shown.

  4. #4
    Board Regular
    Join Date
    Sep 2017
    Location
    Houston, TX
    Posts
    257
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Creat dropdown list with two columns

    Quote Originally Posted by Yaghoub61 View Post
    I need the actual dropdown list to have two columns, one for codes and one for names in one cell. example cell D1
    when the dropdown list open, two columns are shown.

    So a Data Validation list (drop down menu) has a limit of 1 column ... AFAIK.

    But, a Combo Box does allow you to implement more than one column in your dropdown menu.

    Here is a link that gives some good insight into using combo boxes.

    https://contexturesblog.com/archives...rop-down-list/

    Basically, you would need to create a table where the Code - Name relationships are established.

    Then your Combo Box drop down menu would give you a list of all the combos you have listed in your table. You then select the one you need.

    Just keep in mind, if you have for example 15 codes and 20 names, you could have up to 300 different code/name combinations. You would need to have all 300 combinations in your source table so that they correctly populate into your Combo Box drop down menu.

    ---------------------------------

    Now, if you want to use data validation instead of a combo box, you could do a cascading list, but that would take up to 2 cells for the drop down, instead of the one you wanted, because a Data Validation drop down menu is limited to one column.

    You would only need two tables, one of the 15 codes and one of the 20 names. So you are gaining one table, but eliminating all 300 combinations.

    Take a look at this link and see if it helps direct you if you want to go down cascading menus.

    https://www.ablebits.com/office-addi...n-lists-excel/

    -Spydey

  5. #5
    New Member
    Join Date
    May 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Creat dropdown list with two columns

    Thank you so much for helping, Spydey

  6. #6
    Board Regular
    Join Date
    Sep 2017
    Location
    Houston, TX
    Posts
    257
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Creat dropdown list with two columns

    Quote Originally Posted by Yaghoub61 View Post
    Thank you so much for helping, Spydey
    You are welcome. Hopefully those links gave you some good starting grounds to achieve what you need.

    Good luck!

    -Spydey

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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