Im looking for a way to setup a data validation where the user has to enter a number within a dynamic range based on a value set by a number in a different cell
So if A1 = 314 I need to make sure the user can only enter values between 4001 and 4365
If A1 is changed to 317 the user has to enter a number between 7001 and 7365
I can easily capture the 3rd digit (4 or 7 in my example) with a RIGHT statement but I need to apply that to the max and min values allowed in the data entry cell.
Any help would be REALLY appreciated
Bookmarks