How do I create a multi-row list box in Excel 2010

Posted on 2011-10-02
Last Modified: 2012-05-12
I have 2 columns of values in excel, lets call them Selection1 and Selection2.

I want to provide users with a drop-down that allows them to select either 'Selection2' or 'Selection2'.

Based on their selection, a series of cells would be updated with the values associated with either 'Selection1' or 'Selection2'.

Appreciate any help.
Question by:streetwise99
    LVL 5

    Expert Comment


    You can click Data ==> Data validation option. in the dialog box you select List option and say from where it has to pick. Please find the image for your reference.

    LVL 19

    Expert Comment

    instead of relating them to cell contents, you can also type the values in the data validation box :

    option1 ; option 2

    the user will then have to choose between option 1 and option 2

    LVL 4

    Expert Comment

    Can you post an example workbook showing which cells you want updated based on the drop down list?

    Author Comment

    Refer to the attached screen-shots.

    I have 2 columns, titled 'Selection1' and 'Selection2'. Each of these have a series of data-rows associated with them.

    I want to create a drop-down that allows users to choose either 'Selection1' or 'Selection2'. Based on their selection the associated data cells below will update.

    User has selected 'Selection1' from drop-down
     User has selected 'Selection2' from drop-down
    LVL 5

    Accepted Solution


    you can use the formula like, =IF($H$4=$D$4,D5,IF($H$4=$E$4,E5,"None"))

    Please refer the sample workbook.


    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Suggested Solutions

    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now