Concatenation within IMPORTRANGE

by Justin Cohen   Last Updated August 14, 2019 12:03 PM

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



Related Questions



IMPORTRANGE row limit?

Updated August 27, 2018 17:03 PM

Force `imortrange()' to update data

Updated April 24, 2019 17:03 PM

Restrict ImportRange to only visible rows

Updated November 06, 2018 00:03 AM

What spreadsheets import from my spreadsheet?

Updated December 31, 2018 07:03 AM