Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If(match(State,'CA','OR','WA'),'West area',If(match(State,'TX','LA','MS','AL','FL'),'Gulf area,
If(Match(State,'ME','MA','RI','CT','NJ','DE','MD','VA','PA','NY'),'North-East area')))
So I am categorizing states as regions for the master item dimension. Is there any other way for the syntax???
Thanks in advance.
you can try with the combo Pick (match())