• 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


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

Multiple Data Validations based on an IF ?


New Member
I would like to be able to have something like the following
IF(B5=C5 then return Data validation list 1
IF(B5=C6 then return Data Validation list 2
IF(B5=C7 then return Data Validation list 3
else "")

But no idea if this is possible or how to go about it if it is, could anyone help please?
how about
in data validation
But what is in the ELSE ?
I have used range K1:K10 and so will be blank

see E5


  • data_Val-etaf.xlsx
    10.4 KB · Views: 4