Error validating the formula
A common issue when creating dependent lists is the use of illegitimate characters in named ranges.
You cannot begin named ranges with a number, or use spaces and some other symbols.
For these lists, the item selected in one list will affect what options appear in the next list.
In the example below, we have a list of cities in cell F2.
It controls what can be input into a cell, to ensure its accuracy and consistency. In this blog post we will explore 11 useful examples of what Data validation can do.
E1000= A2-E1000; The following 2 workarounds can be used to resolve the problem I. If E1000 is for Plan Type 1,2 and 3; enable A2 for the same Plan Types), 5. Maybe users are recording a transaction that has occurred.