Dynamic ValueList

[johnso2080]

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