Populate cell dropdown list based on what is selected in other cells

[android1]

Hi,

Bit lost with this.

I have a column L whose cells contain the dropdown options

Almost Certain (5)
Likely (4)
Possible (3)
Unlikely (2)
Rare/Remote (1)

Based on what is selected in column L, I want the corresponding cell dropdown list in column M to populate using following rules -

If L = Almost Certain (5) then M = 5,10,15,20,25
If L = Likely (4) then M = 4,8,12,16,20
If L = Possible (3) then M = 3,6,9,12,15
If L = Unlikely (2) then M = 2,4,6,8,10
If L = Rare/Remote (1) then M = 1,2,3,4,5

 

[spydey]

So to me, it looks like you are searching for a dynamic data validation.

I just did something similar to this today. This article was quite helpful:

https://excelsemipro.com/2011/05/a-dynamic-dependent-drop-down-list-in-excel/

Granted, this does require that you setup a table and about 2 or 3 defined ranges, but it is pretty simple if you follow the article.

Just adjust for what you need.

When I set mine up, it worked great!

-Spdyey