Hi All,

I can't understand why this Data validation is not working.

In A4 I have the value '2008', with the name FIN_year.

Also A1 = FIN_year.

I want to validate A1 to only keep the value of FIN_year.

So in Data Validation I set in:
Settings:
Allow: Custom
Formula: =INDIRECT(FIN_year) [I also tried just '=FIN_year').

In Error Alert: I ticked the "Show error alert after invalid data is entered"
Style: Stop
Title: Error, wrong Data is entered
Error message: This value is equal to FIN_year

Then clicked OK.

However when I try to overwrite the value in A1, it allows me to put in invalid values without any error warning.

Could anyone kindly explain how to correct this problem.

regards,