select multiple values

[ali_hijazi]

Hello

I want to select multiple values of a column whenever the user selects a specific sheet

I used the following:

("IN"|"OUT") and it is working properly

but Now I want to select IN and OUT or LEFT and RIGHT depending on the value of the variable vView

what would be the syntax with an IF statement?

please advise

[sunny_talwar · Accepted solution]

May be like this:

=If(vView = 1, '("IN"|"OUT")', '("LEFT"|"RIGHT")')