Hello,
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
VariableA:
=IF(condition=true,
" 'Value1','Value2','Value3' "
,
" 'Value4','Value5','Value6' "
)
Expression:
=IF(ValueList(VariableA) = 'Value1'
,
Result 1
,
If ValueList(VariableA) = 'Value 4'
,
Result 2
)
)
Can anyone explain how to go about this? I've tried a number of different ways but it doesn't seem to be working?
Thanks
