Is there any way to return the two columns in the choose function
For example, here in excel (image), I can do it with:
=CHOOSE({1\2};B1:B10;A1:A10)
formula in excel
Is there a way to do this in google sheets? Or some similar formula?
try:
={C1:C11\ A1:A11}
or if your sheet is english:
={C1:C11, A1:A11}
={F1:F12, A1:E12}