I want to create a variable that provides a string (based on conditions) to be used as an argument for a ValueList() function.
Basically something like
" 'Value1','Value2','Value3' "
" 'Value4','Value5','Value6' "
=IF(ValueList(VariableA) = 'Value1'
If ValueList(VariableA) = 'Value 4'
Can anyone explain how to go about this? I've tried a number of different ways but it doesn't seem to be working?