+ Reply to Thread
Results 1 to 5 of 5

Displaying selections from dropdown menus

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

    Displaying selections from dropdown menus

    I am using a drowdown cell to allow users to select a rating of 0 through 3 that is followed by a description of what that rating entails. I am then using nested if statements do display the score portion of the selection, but not the description. This question may be vague but is there a way to do this without having to enter the entire string of the selection into the if statement? The end user doesn't want the descriptions separated the rankings and ideally I would like to be able to copy and paste the display formula to apply to multiple dropdowns.

    example of what I have now

    dropdown cell A1 options:
    0- less than 10% chance of success
    1- between 10% and 25% chance of success
    2- between 25% and 75% chance of success
    3- highly likely with greater than 75% chance of success

    display cell:
    =IF(A1="0- less than 10% chance of success",0,IF(A1="1- between 10% and 25% chance of success",1,IF(A1="2- between 25% and 75% chance of success",2,IF(A1="3- highly likely with greater than 75% chance of success",3))))

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

    Re: Displaying selections from dropdown menus

    Set up your little table somewhere, let's say in G1:H4 so that G1 = 0, H1 = less than 10% chance of success and so on. Then you can use VLOOKUP instead of the IF statement
    =VLOOKUP(A1,$G$1:$H$4,2,FALSE)
    Does that work for you?
    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

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

    Re: Displaying selections from dropdown menus

    That helped a lot. I ended up going with HLOOKUP instead, but same gist. Thanks
    It seems to be picky with where the ratings are relative to the selections (requires them to be below the rows of selections vs. above using hlookup), but still gets the job done and I can continue to play around with it.

    Thanks for helping a novice

  4. #4
    Forum Expert Whizbang's Avatar
    Join Date
    08-05-2009
    Location
    Greenville, NH
    MS-Off Ver
    2010
    Posts
    1,395

    Re: Displaying selections from dropdown menus

    This link is a great resource for alternatives to the IF function.

    http://www.excelhero.com/blog/2010/01/i-heart-if.html

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

    Re: Displaying selections from dropdown menus

    Very helpful. Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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