CODEWITHSUNDEEP
arraysgoogle-sheetsgoogle-sheets-formulanamed-rangesimportrange
user3062853
user3062853

Reputation: 91

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"

Upvotes: 4

Views: 4808

Answers (2)

Rich1000
Rich1000

Reputation: 1

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

Upvotes: 0

player0
player0

Reputation: 1

put them in array:

={B2:100; D2:D100}

or:

={drinks; food}

or:

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

Upvotes: 2

Related Questions