0 Replies Latest reply: Jan 31, 2013 8:17 AM by Darren Johnson RSS

    Dynamic ValueList

    Darren Johnson

      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