+ Reply to Thread
Results 1 to 6 of 6

Display information based on dropdown selection

Hybrid View

  1. #1
    Registered User
    Join Date
    04-12-2014
    Location
    Earth
    MS-Off Ver
    Excel 2003
    Posts
    21

    Display information based on dropdown selection

    Hello everyone,

    I'm wondering how I could display information based on the user input through dropdown selection. I know how to make a dropdown-list already.

    Example:
    A1 has a dropdownlist with Apple and Banana in it. If I select banana then I want B1 to display "8" and if I select Banana I want B1 to display "4".

    Hopefully someone can help me out with this problem.

    Thanks in advance

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,732

    Re: Display information based on dropdown selection

    If you look at this video by Mike Alexander may be what you are looking for. At 1 minute and 55 seconds of this video he talks about what I think you are trying to do.

    http://www.datapigtechnologies.com/f...tcontrols.html
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Display information based on dropdown selection

    Here is just one of few other options:

    In B1

    =LOOKUP(A1,{"Apple","Banana"},{8,4})

    A
    B
    1
    Banana
    4
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Display information based on dropdown selection

    If you have a lot of "options", make a small table and use vlookup()
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    04-12-2014
    Location
    Earth
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: Display information based on dropdown selection

    Thanks for the replies guys, I've been using the lookup functionality so thank you for introducing me to that.

    When I'm using =LOOKUP(A1,{"x1,"x2","x3","x4","x5","x6"},{1,2,3,4,5,6})
    And use x1,x2,x3,x4,x5,x6 in my validation list everything works perfectly.
    But once I change my validation list and formula into longer things than x1, x2 etc they will display the wrong values and the last word in my list even displays an error: #N/A Did not find value 'doesntmatter' in LOOKUP evaluation. I've tried looking the error up but it just seems bugged or something. I've checked it multiple times and even copied it to make sure I was using the exact names. Any ideas?

    Also, is there an option to populate multiple cells by selecting something from the dropdown menu rather than just 1 cell?

    Thanks guys!

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Display information based on dropdown selection

    Try vlookup instead...

    A
    B
    22
    x1
    1
    23
    x2
    2
    24
    x3
    3
    25
    x4
    4
    26
    x5
    5
    27
    28
    x1
    1


    B28=VLOOKUP(A28,$A$22:$B$26,2,0)

+ 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. Replies: 2
    Last Post: 10-07-2013, 11:06 AM
  2. [SOLVED] Populating information based on selection from dropdown list
    By kearbear in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-10-2013, 11:16 PM
  3. Cull dropdown list options based on selection in another dropdown
    By Kiffar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2012, 01:53 AM
  4. Selection from Dropdown to Generate new table Information
    By JenniferHadsell in forum Excel General
    Replies: 5
    Last Post: 07-10-2012, 10:09 AM
  5. Replies: 1
    Last Post: 02-17-2012, 05:19 PM

Tags for this Thread

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