+ Reply to Thread
Results 1 to 6 of 6

Excel Drop Down Menu - Select List Item - (Show Data Associated With That List Selection.)

  1. #1
    Registered User
    Join Date
    04-11-2014
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2013
    Posts
    2

    Excel Drop Down Menu - Select List Item - (Show Data Associated With That List Selection.)

    Hello,

    I have created a drop down list.

    My goal is the following: Once an item from the list is selected, I want other data associated with that item to be pulled up in a row or column on the same worksheet.

    How do I do this?

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,773

    Re: Excel Drop Down Menu - Select List Item - (Show Data Associated With That List Selecti

    Use VLOOKUP or INDEX/MATCH to bring back the data using the selected drop down list value as the reference.

    If you need more help than that, perhaps you could post some example data with details of what data you wish pulled up.

  3. #3
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Re: Excel Drop Down Menu - Select List Item - (Show Data Associated With That List Selecti

    That depends on the type of data you want to pullup. But, one option is to have lookups like the attached.

    Choose from the "GRAY" dropdown list.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-11-2014
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Excel Drop Down Menu - Select List Item - (Show Data Associated With That List Selecti

    Perfect. I will compose a Vlook up and get that going. Thank you both for the prompt response.

  5. #5
    Registered User
    Join Date
    04-11-2014
    Location
    British Columbia, Canada
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Excel Drop Down Menu - Select List Item - (Show Data Associated With That List Selecti

    I require the same help as well. To make things simple lets try to break down the lengths of a couple different items.

    Take the following image:
    excel help.jpg

    So I manually enter WIDTH and HEIGHT and select the TYPE from a drop down list (its either O, XO, O/V)

    I want the rest of the cells to fill automatically.

    So TYPE O would only have Left Side, Right Side, Top, Bottom

    TYPE XO would have Left Side, Right Side, Top, Bottom, and VERTICAL MIDBAR

    TYPE O/V would have Left Side, Right Side, Top, Bottom, and HORIZONTAL MIDBAR

    Your help is appreciated

  6. #6
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Excel Drop Down Menu - Select List Item - (Show Data Associated With That List Selecti

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. Excel drop down, automatically show list for selection
    By KALATRASH81 in forum Excel General
    Replies: 1
    Last Post: 01-08-2014, 07:37 AM
  2. [SOLVED] Select from drop down list to show another drop down list in a different cel
    By ExcelRanger in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-22-2012, 04:27 PM
  3. Show the first Item in a drop down list as a default.
    By jpaulobautista in forum Excel General
    Replies: 0
    Last Post: 12-08-2011, 06:55 PM
  4. How do I use one list drop down menu result to select another list?
    By steveinspain in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-02-2007, 02:59 PM
  5. Select item in drop-down list in Vbasic
    By ramza in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2006, 05:59 AM

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