+ Reply to Thread
Results 1 to 8 of 8

Creating a dropdown list using matching data from 2 columns to populate the list.

  1. #1
    Registered User
    Join Date
    06-11-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    11

    Creating a dropdown list using matching data from 2 columns to populate the list.

    Hi I'm creating a spreadsheet to keep track of my costs of production in an online game. Within the game there are a range of spawned resources that appear for only a short time before being unobtainable these resources have specific types that is shared between multiple spawns of the resource but each resource spawn has a unique name.

    My first worksheet lists all the resources and their various qualities and the later worksheets are meant to allow me to choose from a list resources matching the requirements of the item I'm looking to craft. The example i have shown in the second picture requires Tatooinian Fiberplast and Lokian Wild Wheat to craft so in the Chosen Resource column I would like to have a drop down list allowing me to select the named resource type i would like to use - for Tatooinian Fiberplast the only thing on the list should be Omnitwixi and for the Wild Wheat it should show Fizi and Krad


    http://i.imgur.com/9ju5Tnv.png

    http://i.imgur.com/pTuvDQN.png

    I am aware there are people with more pressing problems than computer games and as such I understand if you aren't willing to take the time to help but any time you can spare to help me out would be greatly appreciated

    Thanks again

    CraftyGamer
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by CraftyGamer; 06-11-2013 at 12:43 PM.

  2. #2
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Creating a dropdown list using matching data from 2 columns to populate the list.

    Pictures of workbooks seldom get much response from anyone, especially when as complex as yours.

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    06-11-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Creating a dropdown list using matching data from 2 columns to populate the list.

    I added the spreadsheet - there's nothing sensitive as its just for a computer game. The columns from server rank right on the first sheet can be ignored as they just denote the quality of the resources and aren't required in what I'm trying to do. The goal is basically for the Components sheet to be able to lookup the specific resource and resource columns and find matches in the resources sheet. Once these matches have been found it should then allow a dropdown box in the chosen resource column allowing you to chose the from the corresponding resource name column.

    The worksheet currently has a dropdown for the chosen resource column but it doesnt filter the results to match just shows the entire list.

  4. #4
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Creating a dropdown list using matching data from 2 columns to populate the list.

    Okay can't look now, but will look back later.
    If nobody else takes this on I'll have a go at it.

  5. #5
    Registered User
    Join Date
    06-11-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Creating a dropdown list using matching data from 2 columns to populate the list.

    Ok thanks a lot I appreciate any help I can get.

  6. #6
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Creating a dropdown list using matching data from 2 columns to populate the list.

    I'm not to sure what you are trying to achieve.

    See if this gives you a start.

    1/. I have extracted a list of Unique "Specific Types" from your data sheet (Sheet1)
    These are used as headers in Sheet "LookupSpecific" I then filled, as best I can, the values associated with each Type.

    2/. Sheet "LookupResources" is built in a similar way.

    3/. These sheets are then used as lookup Tables for the Data Validation Lists in Sheet2 columns B:C.

    4/. All the Names used are fully dynamic, so you can add to the lists as required, the formulae will adjust to suit.
    The lists can be any length up to 10, but must be continuous, i.e. no blanks.
    10 seemed a reasonable limit based on the information given.

    5/. Select from the drop-down in Sheet2 Column A, then in Column B, the last option(s) will be in the drop-down in Column C.

    Is this what you want to do?
    Attached Files Attached Files
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  7. #7
    Registered User
    Join Date
    06-11-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Creating a dropdown list using matching data from 2 columns to populate the list.

    Thanks a lot that's perfect for what I was trying to achieve.

  8. #8
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Creating a dropdown list using matching data from 2 columns to populate the list.

    Happy to hve helped ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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