Google Sheet Named Range Multiple Columns

Question

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"

Answer 1

put them in array:

={B2:100; D2:D100}

or:

={drinks; food}

or:

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