4

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"

player0
  • 124,011
  • 12
  • 67
  • 124
user3062853
  • 91
  • 1
  • 8

2 Answers2

2

put them in array:

={B2:100; D2:D100}

or:

={drinks; food}

or:

={IMPORTRANGE("ID", "B2:B100"); IMPORTRANGE("ID", "D2:D100")}
player0
  • 124,011
  • 12
  • 67
  • 124
0

Based on the title of this question someone might find it useful to know that you can create a named range with multiple columns and all rows by omitting the row numbers.

For instance, a named range on a tab called 'tab_1' that includes columns A to C, and all rows, including those added to the sheet after the creation of the named range is created using this formula

'tab_1'!A:C
Rich1000
  • 1