+ Reply to Thread
Results 1 to 11 of 11

drop down menu help

  1. #1
    Registered User
    Join Date
    01-03-2014
    Location
    omaha,ne
    MS-Off Ver
    Excel 2010
    Posts
    26

    drop down menu help

    I have a drop down menu that consist of 15 different numbers. when I pull down the drop down menu and select one of the numbers I would like it to equal the description I gave that number. For example when I select job number 1545 from the drop down menu I would like the"level 52 floor" to come up in to a selected cell. I hope I described this well enough and thanks in advance.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: drop down menu help

    In an adjacent cell you can have a VLOOKUP formula, something like this:

    =IF(drop_cell="","",VLOOKUP(drop_cell,your_table,2,0))

    where drop_cell is the cell reference of the cell with the drop-down, and your_table is the area of your sheet where you have the numbers and descriptions listed - in future it would be better to quote which cells you have used.

    Hope this helps.

    Pete

  3. #3
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: drop down menu help

    Hi Chris,

    Happy New Year, and welcome to the forum.

    I think the best way to achieve this is to use VLOOKUP in the adjacent cell to the Drop Down Box.

    Suppose you have the dropdown in A1, and the List which generates the dropdown in D1:D15 (with the descriptions next to them).

    =VLOOKUP($A$1,$D$1:$E$15,2,0) will do what you want. (I use 0 as the last argument instead of FALSE I find it more efficient - less keystrokes).



    Please remember, your request is clearer if you attach a sample workbook.
    - Click on Go Advanced and click on the Paper Clip.
    When you reply please make it clear WHO you are responding to by mentioning their name.
    If this has been of assistance, please advise. A little thanks goes a long way.
    - Please click on the *Add Reputation button at the bottom of helpful responses.
    Please mark your thread as SOLVED:
    - Click Thread Tools above your first post, select "Mark your thread as Solved".

  4. #4
    Registered User
    Join Date
    01-03-2014
    Location
    omaha,ne
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: drop down menu help

    ok here is what i have with cell names to se if that will help more. on sheet1 in c2 i have a drop down menu in cell d2 is where i need the definition to go. on sheet2 in a1-a15 i have the values for the drop down menu and in b1-b15 i have the definitons for cell a1-a15. hope this hlps thanks

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: drop down menu help

    Put this formula in D2 of Sheet1:

    =IF(C2="","",VLOOKUP(C2,Sheet2!$A$1:$B$15,2,0))

    Hope this helps.

    Pete

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: drop down menu help

    Hi and welcome to the forum

    Did you try to adjust the references in the suggested formulas - they should work just fine if you apply your references?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  7. #7
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: drop down menu help

    =VLOOKUP(C1,Sheet2!$A$1:$B$15,2,0) will give you what you want.

    Regards,

    David

  8. #8
    Registered User
    Join Date
    01-03-2014
    Location
    omaha,ne
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: drop down menu help

    I keep getting "false" as a answer in d2.

  9. #9
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: drop down menu help

    Take a detailed look at the formula I gave you - it contains double-quotes comma double-quotes comma (i.e. repeated twice), but I suspect you have only typed that part once.

    Hope this helps.

    Pete

  10. #10
    Registered User
    Join Date
    01-03-2014
    Location
    omaha,ne
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: drop down menu help

    I got it thank you guys very much.

  11. #11
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: drop down menu help

    You're welcome, Chris - glad you got it working in the end.

    If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

    Also, since you are relatively new to the forum, I would like to inform you that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

+ 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. Replies: 1
    Last Post: 02-07-2013, 11:03 AM
  2. [SOLVED] I cant work out how to create a drop down menu that relates to another drop down menu
    By louise2613 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-18-2012, 01:49 PM
  3. Replies: 0
    Last Post: 06-25-2012, 03:22 PM
  4. Replies: 2
    Last Post: 01-30-2009, 04:23 PM
  5. [SOLVED] Drop down menu-How do you produce a drop down menu in a single cell in Excel
    By Freddo in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-04-2006, 04:35 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