If you have continius range then {A1,A2,A3,A4} is A1:A4
Or you can use CHOOSE({1,2,3,4},A1,A2,A3,A4).
Last one could be use for any set such as A1,C22,D34,V45
CHOOSE({1,2,3,4},A1,C22,D34,V45)
Please use appropriate separator for horizontal or vertical array.
Bookmarks