• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Validation if adjacent cell has specific list

skyh3ck

Member
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

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

Attachments

  • validation if.xlsx
    8.7 KB · Views: 2
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
 

Attachments

  • DV validation if AliGW.xlsx
    9.1 KB · Views: 1
Last edited:
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

75137
 

Attachments

  • DV (BY).xlsx
    10.5 KB · Views: 5
Back
Top