Data Validation Lists Based On IF Formula

Question

Could a data validation be set on a LIST and the source be result of another cell but values hard coded instead of being a cell(s) reference?

For example something like:

Selecting List in the Validation Criteria allow but Source containing a formula like

=if(A1>100,{"A","B","C","D"},{"E","F","G","H"})

Instead of a cell reference via Indirect and Named Ranges?

Answer 1

Unfortunately, no. If you try to use a constant array, you get an error message

"You may not use reference operators (such as unions, intersections and ranges) or array constants for Data Validation criteria."

The list must be a delimited list, or a reference to a single row or column.