CODEWITHSUNDEEP
arraysimportsyntaxrangegoogle-sheets-formula
Stuart
Stuart

Reputation: 325

Importrange following another importrange

Is it possible to have one importrange follow another?

The purpose of this would be where there are such large data sets that they have needed to be put into different separate sheets to collate other data and now parts of the sheets need to be put back into one sheet

Upvotes: 1

Views: 34

Answers (1)

player0
player0

Reputation: 1

you can have them in array like:

={IMPORTRANGE("url1"; "sheetname!A1:C10"); 
  IMPORTRANGE("url2"; "sheetname!A1:C10")}

but before you do so each unique importrange needs to be run as standalone function to connect the sheets by allowing access - if not you will get an array error

Upvotes: 1

Related Questions