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

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.

2. ## 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:
`Please Login or Register  to view this content.`

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