arraysgoogle-sheetsgoogle-sheets-formulanamed-rangesimportrange

Google Sheet Named Range Multiple Columns

In Column B I have drinks listed from B2:B100, In Column D I have food items listed from D2:D100. In another google sheet I need to have a single dropdown that needs to pull all the drinks and food items. I created a named range from B2:B100 and called it drinks. I have the importrange working to pull the drinks named range.

How can I get a named range of "drinks and food" with the value of B2:100 & D2:D100. Then I will update my name range parameter in the importrange with the "drinks and food"

Solution

  • put them in array:

    ={B2:100; D2:D100}

    or:

    ={drinks; food}

    or:

    ={IMPORTRANGE("ID", "B2:B100"); IMPORTRANGE("ID", "D2:D100")}