+ Reply to Thread
Results 1 to 5 of 5

Drop down lists won't return specific data in second drop down menu, just 0.0

  1. #1
    Registered User
    Join Date
    01-27-2014
    Location
    Hull, U.K.
    MS-Off Ver
    Excel 2007
    Posts
    3

    Drop down lists won't return specific data in second drop down menu, just 0.0

    Hi Excel Forum et all, Tearing my hair out over functions problem, re-drop down lists etc.
    I've got a list of data, which is the subject of a drop down box. When i click on the drop down box of 5 items (which all relate to different and increasing floor areas) i will choose one of those options, which i want to then lead to either another drop down box containing a set of 5 different costs or default a set cost depending on which choice i select from the first drop down.
    I've gone througn about 10 otr so online tutorials, following the examples exactly, but none works. I've tried VLOOKUP, IF, MATCH & INDEX, but nothing works.
    I did get one result from selecting the top choice on the first drop down, which selected the top choice in my second list, using the IF function, but couldn't get it to work when selecting choices 2-5 in my first list and the required 2-5 costs in the second list.
    HEEEEEEEEEELPPPPP!!!

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Drop down lists won't return specific data in second drop down menu, just 0.0

    Are you able to provide a sample of your work, or at least create one for us to play with?

    There's a number of solutions involving data validation lists, but it's difficult to say which one will work for you until we see what you need it for.

    The most common is to name each successive list with the Name Manager under the Data tab, after a selection from a previous list.

    Therefore, if your first list is names in A1 and Bob is a name on the list, then another list might be named Bob with the name manager, and refer to it. The second dropdown list would have a formula =INDIRECT(A1) to pull the word Bob and evaluate it to mean the list Bob.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    01-27-2014
    Location
    Hull, U.K.
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Drop down lists won't return specific data in second drop down menu, just 0.0

    HI and thanks for your response.
    I've uploaded my file and the problem is on the Domestic Fees Tab.
    The drop down list in Cell B5 contains the 5 choices from Cells Q4-8. When I select one of these choices I want it to default one of the values in the corresponding cells U4-8 to Cell I5.
    Once I've done this I can replicate for the rest of the sheet.
    regards

    Job Sheet Template.xlsx

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Drop down lists won't return specific data in second drop down menu, just 0.0

    =VLOOKUP(B5,Q4:U8,5,FALSE)
    you need to use 5 because you are merging cells.
    Is that what you were looking for?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  5. #5
    Registered User
    Join Date
    01-27-2014
    Location
    Hull, U.K.
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Drop down lists won't return specific data in second drop down menu, just 0.0

    Hi Chemist B,

    Excellent - Problem solved and thanks for your solution, it's greatly appreciated.

    Regards

    Torchdesign

+ 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. If drop down menu equals one of 5 lists, on a certain day of the week, then..
    By o0needia0o in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-01-2013, 11:17 PM
  2. Replies: 2
    Last Post: 03-11-2013, 02:22 PM
  3. Drop down menu lists
    By krlmlt89 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-30-2012, 01:51 AM
  4. drop down menu that lists locations
    By Pisces in forum Excel General
    Replies: 2
    Last Post: 07-07-2010, 07:33 AM
  5. Inserting lists from a drop down menu????
    By Jim Johnson in forum Excel General
    Replies: 2
    Last Post: 12-29-2005, 02:39 PM

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