In a data validation setting I want to show the concatenation of two named ranges.

I can do this by concatenating them on a worksheet with the VSTACK funtion, applying a new range name to the result, and referencing the new range name in the data validation.

That works, but is clumsy and takes some maintenance if the constituent ranges change in size.

I tried creating a named range with the definition =VSTACK(Range 1,Range2) then referencing that name in the data validation, but it wasn't accepted.

Neither did entering this in the data validation setting =Range1 & Range2



Is there another simple way to have two ranges in a data validation setting ?