I have two sheets in my workbook named
'Personel' sheet has three columns that contains a list of Person's ID, Name, and Contact Number.
'Task' sheet contains their tasks.
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.