Excel - cell number in the Import range function

Here is an importrange function I made in Google Spreadsheets:

=IMPORTRANGE("google.doclink","DE_copy!B3:B3")

I thought if I just drag it down, then the cell number in the function will be changed automatically, like:

=IMPORTRANGE("google.doclink","DE_copy!B4:B4")
=IMPORTRANGE("google.doclink","DE_copy!B5:B5")

But the number doesn't change at all. Is there anyone who can let me know what is the problem?

Thanks a lot in advance!

worksheet-function
google-spreadsheets

Yon

Posted 2019-08-16T14:43:46.373

Reputation: 1

The second paramater is a string, so I assume you just have to build the string. Maybe using ADDRESS? For example: =IMPORTRANGE("google.doclink","DE_copy!"&ADDRESS(ROW(B3),2,4,TRUE)). Also, you have used microsoft-excel as a tag. You might want to change that. – JvdV – 2019-08-16T14:47:18.227

Hi JvdV, thanks a lot, it works perfectly! – Yon – 2019-08-16T15:51:19.287

Would you accept an answer if I post my suggestion? To close of the the thread? – JvdV – 2019-08-16T16:02:34.127

Excel - cell number in the Import range function

No answers