Dynamic Validation if adjacent cell has specific list

[skyh3ck]

Hey Gurus

I wan to prepare data where two column or multibple column has validation list.
For Example, column 1 has one validation selection, and based on that column 2 should have its own validation section


If A is selected that next cell should have only its own list in column B and so on

 

[AliGW]

Using Named Ranges for Sub-Lists

The first column uses a regular DV list, and the second uses a DV list with this as the source: =INDIRECT("Set"&$D2)

Named ranges are:

SetA
SetB
SetC

 

[bosco_yip]

Another option using formula only

1] Data validation in "Column A", D2 >>with Allow : List >> Source: =$G$3:$G$5

2] Data validation in "Column B", E2 >>with Allow : List >> Source: =OFFSET($J$1,MATCH($D2,$I:$I,0)-1,,3)

and all copied down

 

[AliGW]

Four days and not even a 'thank you'. Note to self: don't bother wasting your time in future,.

 

[shrivallabha]

Four days and not even a 'thank you'. Note to self: don't bother wasting your time in future,.

Look at OP's avatar, someday I am sure "he'll be back!"