+ Reply to Thread
Results 1 to 4 of 4

Choosing a worksheet with drop down list then selecting data with another drop down list

  1. #1
    Registered User
    Join Date
    04-13-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    3

    Choosing a worksheet with drop down list then selecting data with another drop down list

    I feel as if there is a simple solution to this problem I am having and I can't seem to figure this out.

    I am trying to create a troubleshooting log that gives the user all the information at his/her fingertips.

    I need a way to link the the first drop down list to the second drop down list ( Both marked in yellow on EXAMPLE, the second drop down list being "alarm code")

    The first drop down list will be selecting the model number of the unit and the second drop down will be selecting the alarm code that corresponds to the unit. Then the remaining information will be selected by using ( I am assuming) a VLOOKUP function.

    The things I can't figure out:

    1) How to select a model which is different on each sheet and link it to the alarm code drop down list

    2)What function to use in the "description" "cause" and "remedy" cells


    Help will be much appreciated, or at least a link or place to get started. I tried data validation and a few other functions without success, I am trying to stay away from VBA because I am not very familiar with it

    Thanks,
    Mike

    EXAMPLE.xlsx

  2. #2
    Registered User
    Join Date
    06-16-2011
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    42

    Re: Choosing a worksheet with drop down list then selecting data with another drop down li

    U can use "Indirect" function to link first drop down to second dropdown,but for this u need to create the Table for Model vs Alarm Code.

    In the attached sheet I dont see any value for Model... Please update the sheet and post it.

  3. #3
    Registered User
    Join Date
    04-13-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Choosing a worksheet with drop down list then selecting data with another drop down li

    The model is marked on the tabs of the excel workbook. I want the first drop down list to show the models and the second to list the corresponding multiple alarm codes of that model. (These alarm codes can be different for each model or exactly the same as shown). I hope that clarifies the situation.

  4. #4
    Registered User
    Join Date
    04-13-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Choosing a worksheet with drop down list then selecting data with another drop down li

    Any help would be much appreciated thanks

+ 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