I have a question regarding the importrange()
function. This is my formula:
=ImportRange("1u0TjjekVHHb6shYiSWoo0W1ygxuSu2tVvLstnEE1NFo";"Juillet!I5")
I have about 20 rows of data in the Juillet
sheet. In order to quickly change the sheet in all the formulas, is it possible to get the sheet name in this formula through a reference to a cell?
For example, let's say that cell A1 contains a month name like Juillet
or Novembre
. How can I get the value in cell A1
embedded in an importrange()
formula?
What I would like to do is something like this:
=ImportRange("1u0TjjekVHHb6shYiSWoo0W1ygxuSu2tVvLstnEE1NFo";"A1
!I5")