I need to import a range of data from one Google spreadsheet to another but I keep getting the error:
"Cannot find range or sheet for imported range using this formula"

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/xxxxxxxx/edit#gid=190222386","Retail Sales!G9:G39")
  • Welcome. The error message looks to be very straight forward and the question doesn't include enough details to figured out why you are getting troubles to fixing it. Please add more details so we could give you a specific answer rather than one based in guessing them. – Rubén Jan 23 '20 at 16:30
  • Ruben; I'm new to this so I will attempt to provide what you need. I want to pull the sum of the range G9:G39 to another workbook. Each workbook has multiple sheets. The sheet I am trying to pull data from is Retail Sales. I'm not sure if this helps or not, as I said I'm new to this forum and new to using google sheets. – Sandy Jan 23 '20 at 17:20
  • You could add screen shots and also try to reproduce the problem in a couple of demo spreadsheets shared to anyone with the link to view only so we could take a look to them. This is recommend to enable us to see if there is anything that you are missing to mention. – Rubén Jan 23 '20 at 17:44
  • Regarding being new in this site, please take the tour and read How to Ask. – Rubén Jan 23 '20 at 17:45

The issue to your question has nothing to do with the IMPORTRANGE function.

It is about your reference to the sheet.
You need to enclose the name of the sheet in single quotes, because the name of the sheet itself has a blank space between the words.

As from the official help site on "Get data from other sheets in your spreadsheet":

If a sheet name contains spaces or other non-alphanumeric symbols, include single quotes around it

In your case use 'Retail Sales'!G9:G39 and surround this with double quotes.

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1SakMhmfUS-N7_zjOHLWL-dS75sxxqFtxn7aGfPsy3IA/edit#gid=190222386","'Retail Sales'!G9:G39")

You can also read more about IMPORTRANGE

  • Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. – marikamitsos Jan 23 '20 at 18:52
  • The OP formula is fine – Rubén Jan 23 '20 at 20:53
  • 1
    "When a reference is passed as text (quote enclosed) it's not required to use the single quotes". That works as well. Still. I always used the safe way and included the single quotes. – marikamitsos Jan 23 '20 at 21:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.