Explanation
In this example, the goal is to join two one-dimensional ranges together horizontally.
This can be done with the CHOOSE function andarray constant.
The CHOOSE function
TheCHOOSE functionis used to select arbitrary values by numeric position.
Applications
Traditionally, the use of CHOOSE function to combine ranges is used up in trickyarray formulas.
Note: the forthcomingHSTACK functionwill make this use of CHOOSE unnecessary.
The values provided to CHOOSE can include references.
