Is it possible to populate a data validation list from another cells value?

[danbates]

Hi,

I have different QTY values that can be entered into column D via a lookup formula.

So these are the QTY's I have now:

QTY
126, 63, 168, 216, 144, 162, 72, 180, 90, 160, 208, 72, 192, 81, 88, 140. 84, 66, 390, 240, 192, 288, 270.

What I would like is if the QTY's from 126 to 66 are in column D then in the data validation list in column E consists of: D, E, F, G, H, J, K, L, M, N, P.

If column D QTY 390, 240, 192, 288, 270 then I want the data validation list to just be: Azera.

I don't know if this is possible but any information would be very helpful.

Thanks
Dan

 

[danbates]

If the QTY is 192 then the data validation list in column E will have to be D, E, F, G, H, J, K, L, M, N, P, Azera.