'Dynamic URL and Sheet using =Importange

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

arraysgoogle-sheetsimportsyntaxreference


Solution 1:[1]

use:

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

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 player0

Related Questions