If you are like me, then you must have needed to use CHOOSE function. This is basically like “SELECT CASE” statement, but more limited
Back in the old days, we had a nice BASIC command (as in QBasic or GWBasic, before VB even was born) called…
On var Goto 30, 20, 55, 120
Where 30, 20, 55 and 120 are lines in that same program.
This will derive the flow of code into different lines based on the value saved in var.
That cannot be supported anymore, Bummer!
However, in Excel, we have the nice old friend, CHOOSE.
Which does exactly like that.
CHOOSE function does that in a formula way, means you get to decide where the flow of formula goes based on the value.