1

I'm completely stuck on this one -- I need to use IMPORTRANGE function but want to make the sheet it pulls from flexible via concatenation -- here is my formula with a scrubbed URL:

=importrange("https://docs.google.com...",("""'"&B5&"'!$F15"&""""))

This gives me an error "Cannot find range or sheet for imported range"

When I hover over

("""'"&B5&"'!$F15"&"""")

I receive the correct string:

"'Q1 19.08.19'!$F15"

Moreover, when I try a hard-coded version of the formula:

=importrange("https://docs.google.com/...","'Q1 19.08.19'!$F15")

It provides the correct answer, which makes me think this is a structural issue, rather than my code.

Thanks so much for reading!!

J

New contributor
Justin Cohen is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
1

On IMPORTRANGE the apostrophes aren't required. Instead of

("""'"&B5&"'!$F15"&"""")

use

B5&"!$F15"
  • Can I buy you a beer? Thanks : ) – Justin Cohen Aug 14 at 13:08

Your Answer

Justin Cohen is a new contributor. Be nice, and check out our Code of Conduct.

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.