Hi, I would appreciate if you can give some ideas to solve the problem below:
I have a column called "TV Model" on sheet 1, on sheet 2 I have a list of 253 TV Models that are repaired by another company. My question is how can I create a rule when I am inserting any model from sheet 2 to have an alert stating that this TV Model is repaired by other company, but allowing me to insert all other TV models which are not restricted by this rule. The TV models contains capital letters and numbers,
I have tried to create the rule with Data Validation and is generating the Alert for every input.
I have a column called "TV Model" on sheet 1, on sheet 2 I have a list of 253 TV Models that are repaired by another company. My question is how can I create a rule when I am inserting any model from sheet 2 to have an alert stating that this TV Model is repaired by other company, but allowing me to insert all other TV models which are not restricted by this rule. The TV models contains capital letters and numbers,
I have tried to create the rule with Data Validation and is generating the Alert for every input.