VBA to select multiple named ranges

[petrutms]

Hi, i have a depended dropdown data validation that works fine, but the issue is that no matter what i do will always show the blank items, since the list is dynamic and contains formulas.
For example, i have 3 categories, Test1,Test2,Test3, each with their own named range, for example rangeTest1,rangeTest2,rangeTest3. The ranges contain filtered values without blanks.

Now, how can i make the code to display for example rangeTest2 if selected category is Test2, or rangeTest3 id selected category is Test3?
I tried offset methods, table methods, none work because all my cells contain formulas and will appear as blank.

Thanks