+ Reply to Thread
Results 1 to 2 of 2

Change the drop down values, based on selection in other columns(drop downs)

  1. #1
    Registered User
    Join Date
    10-18-2017
    Location
    usa
    MS-Off Ver
    2013
    Posts
    1

    Change the drop down values, based on selection in other columns(drop downs)

    I am trying to create a template for Risk Analysis Matrix. I have 3 drop downs in 3 columns, Column A Called "Risk Severity" with values (ACCEPTABLE, TOLERABLE,UNDESIRABLE,INTOLERABLE). Column B called "Risk Likelihood" with values (IMPROBABLE,POSSIBLE,PROBABLE) and my last column C is a drop down with "Risk Level" with values (LOW,MEDIUM,HIGH,EXTREME). What I want is based on the selection the user makes in column A"Risk Severity" and Column B "Risk Liklihood" to change the value in column C drop down.

    For E.g If A = Acceptable and B= Improbable then C should be Low. If A = Acceptable and B= Possible then C should be Low IF A = Intolerable and B= Probable then C should be extreme so on and so forth.

    All in all I will end up with 12 combinations(4*3) and 4 different values in column C based on those 12 combinations.

    Thanks in advance for your help

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Change the drop down values, based on selection in other columns(drop downs)

    If A2 is your dropdown for Risk Severity and B2 is your dropdown for Risk Liklihood

    then put this formula in C2

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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. [SOLVED] Get multiple columns of unique values based on cascading selection criteria (drop boxes)
    By Spritz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-06-2017, 07:34 PM
  2. Replies: 18
    Last Post: 11-16-2016, 08:01 PM
  3. How to change values based on selection in drop down menu
    By minky2488 in forum Excel General
    Replies: 11
    Last Post: 05-28-2016, 04:25 PM
  4. How to change values based on selection in drop down menu
    By minky2488 in forum Excel General
    Replies: 1
    Last Post: 05-27-2016, 06:10 PM
  5. [SOLVED] Combine 2 data sets into one list based on user selection in drop downs.
    By Sassy13 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-01-2013, 01:46 PM
  6. Auto-update initial drop-down selection based on previous drop-downs
    By thornomad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2010, 09:55 AM
  7. change cell values based on drop down box selection
    By Aniruddha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2006, 05:30 PM

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