Search code examples
arraysgoogle-sheetsgoogle-sheets-formulavlookupgoogle-query-language

Choose function return 2 columns on Google Sheets


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?


Solution

  • try:

    ={C1:C11\ A1:A11}
    

    or if your sheet is english:

    ={C1:C11, A1:A11}
    

    update:

    ={F1:F12, A1:E12}
    

    enter image description here