Excel drop-down list based on cell value

I've seen dozens of posts showing how to create drop down lists based on the value selected in a different drop-down list. That doesn't help me, though.

I'm looking for a way to have a drop-down list based on the result of a FORMULA in another cell.

Ex:
- If a certain condition is met, the cell value is 1
- if a different condition is met, the cell value is 2

- If the cell value is 1, then I want the next cell to have a drop-down list with options Low, Medium, High

Any suggestions?

 

Research conditional formatting or validation.

 

You have to do this kind of an indirect way. The first step is to use an area of cells hidden or on another sheet for your validation list. There should be three cells with the formula something like: =IF($A$2=1,"Low",""). A2 would be the cell with possible values 1 or 2. So the formula says if A2 = 1 then the cell has a value "Low". Otherwise the cell is blank. Do this for medium and high as well.

Part 2: For the cell where you want the list to appear, go to data validation (data then validation or simply ALT + D + L). Select List. Under source, select the range of cells we just created above. You may want to name that range to reduce the possibility of error.

After doing the above steps, the drop down menu will be "Low, Medium, High" if the cell you are referencing is "1", and otherwise it will be blank. If you want another set of possible values for if the cell is not "1" then you can change the formula to something like: =IF($A$2=1,"Low","ASDF").


Is this what you are looking for?

 

That worked like a charm. Thank you for your help!

 

Glad to help!