2

I am looking to use Column Validation.

I have column 1(C1) as choices A or B, column 2(C2) as choices W, X, Y or Z.

If C1 = A then C2 must = W but if C1 = B then C2 must not equal W.

Is there way to do this using the Column Validation?

2

Use an if statement to check column values. The format is IF(condition, value if true, value if false). Your values if true or false would be another value check. So if C1 is A, check if C2 is W, else check if C2 is not W.

=IF(C1="A",C2="W",C2<>"W")

  • Just a clarification.. this is not a "Column Validation" formula. It can be used as an item validation formula in List Settings. Column Validations can only use data from the current column. – Mike Smith - MCT - MVP Mar 21 '18 at 2:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.