Hi!
I searched a solution for this and didn't find any.
What I want to do is to validate that the cell value in "Input" is included in the "Validation list" column. For example:
I can't use a simple data validation with a list because the "List" column is going to be filled using copy & paste, so the validation would be erased.
Is there a way to get this just with formulas? I can't use macros either.
I tried this formula but doesn't work in the way I need.
I'd appreciate any help on this. Thanks in advance!
I searched a solution for this and didn't find any.
What I want to do is to validate that the cell value in "Input" is included in the "Validation list" column. For example:
I can't use a simple data validation with a list because the "List" column is going to be filled using copy & paste, so the validation would be erased.
Is there a way to get this just with formulas? I can't use macros either.
I tried this formula but doesn't work in the way I need.
Excel Formula:
=IF(B2<>D2:D8;"Error";"OK")
I'd appreciate any help on this. Thanks in advance!