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

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

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.