I am trying to creat a data validation on a column where it doesnt allow duplicate entries based of content from another column correspondence to the original entry in the first column. 

Eg:

column A – 1,2,3,4

Corresponded column B – occupied, Not occupied, Not occupied, Not occupied

If someone enters number 1 in column A again, it should trigger error message because the corresponding value in column B says “occupied “

hope this is clarified and hope someone can help 🙂

​I am trying to creat a data validation on a column where it doesnt allow duplicate entries based of content from another column correspondence to the original entry in the first column. Eg:column A – 1,2,3,4Corresponded column B – occupied, Not occupied, Not occupied, Not occupiedIf someone enters number 1 in column A again, it should trigger error message because the corresponding value in column B says “occupied “ hope this is clarified and hope someone can help 🙂   Read More

​