A question about the IMPORTRANGE function.

As shown below, if F3 of sheet A is [Yes], sheet B will be [desired].

= IF (IMPORTRANGE ("https://docs.google.com/spreadsheets/d/access key/edit", "F3") = "yes", "hope", "")

If this is the case, when you get the next F4, copy and paste it into sheet B

= IF (IMPORTRANGE ("https://docs.google.com/spreadsheets/d/access key/edit", "F4") = "yes", "hope", "")

It is inconvenient to add by copy and paste like

and I want to change it to the following specification.

I want to be able to automatically generate F4, F5, F6 ... whenever sheet A is added. Where and how should I change it? Please lend someone wisdom.

  • Answer # 1

    I don't know if I can actually do it, but I'm not sure if F3 or F4 is recognized as a string.

    Specifically, the letters up to F are used, and 3.4 is a function that returns the answer of 3.4.

    The fastest is the ROW function,

    = "F"&ROW (A1), F1
    Just copy it

    A2 = F2
    A3 = F3
    Will return, so it may work.

Related articles