I have two sheets in my workbook named 'Tasks' and 'Personnel'. The 'Personel' sheet has three columns that contains a list of Person's ID, Name, and Contact Number.

enter image description here

While the 'Task' sheet contains their tasks.

enter image description here

How can I give validation to column C of sheet 'Tasks' for it to check its value from column B2:B(n) of sheet 'Personnel'? I've tried providing a range as validation, but it's not accepted.

enter image description here

  • 2
    its works without equal (=) sign – Max Makhrov Apr 15 '16 at 11:54

In order to close the question, I'll post my comment:

its works without equal (=) sign

| improve this answer | |

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.