Drag down the formula of IMPORTRANGE that changes the last value into increment value

Question

I have an IMPORTRANGE formula in Google Sheets and want to apply it in the rest of the cells below. When I drag down the formula, it stays the same:

=importrange("1jhXCPi6RUf8MD7XoYgQsH-E0x768UtVxE3XY_kBrbkE","OCT!F2")

How can I drag a formula and have it automatically increment the value (OCT!F2 should be change into OCT!F3 up to OCT!F118)?

When I drag down this formula, I want it to be like this.

=importrange("1jhXCPi6RUf8MD7XoYgQsH-E0x768UtVxE3XY_kBrbkE","OCT!F3")

Answer 1

You may use row formula:

"OCT!F3" = "OCT!F" & row(A3)

You may also include the range in single importrange:

"OCT!F2:F500"

Be careful: importrange formulas may slow down your sheets.