Dynamic URL and Sheet using =Importange

user_18950511 0
Viewed 19

I'm trying to make a =ImportRange with a dynamic URL and Sheet, but I'm doing something wrong.

https://i.stack.imgur.com/QQRDK.png enter image description here

I've also tryed with ""=Q24"A3:A3") where Q24 = August-September !, but that also give an error. I want to do the same thing with the URL, but I also get an error when I try to do that.

Is it possible and if, which command do i need to use. I hope someone could help me.

Br Anders

google-sheets import syntax reference arrays
1 Answers

use:

=IMPORTRANGE("1HeGmCh3fFgHAfJSIsCIFkFi48PWpXR0iZdBcv4HhSWw"; Q24&"!A3")
user_56326290
Related