0

The formula works on lower column number that I need to get data from but nothing is happening when I need to import data from columns with a higher number.

Following formula works (data imported from column 10)

=ARRAYFORMULA(IFERROR(VLOOKUP(A2:A; IMPORTRANGE(Y1; "'Sheet1'!A4:DB"); 10; 0);))

Following formula doesn't work (I need data from column 160)

=ARRAYFORMULA(IFERROR(VLOOKUP(A2:A; IMPORTRANGE(Y1; "'Sheet1'!A4:FZ"); 160; 0);))

My first thoughts were that it just needs some time but even after two days nothing is happening NOTE - Y1 contains the sheet ID in my spreadsheet

1
  • well, 160th column is FD so try:

    =ARRAYFORMULA(IFERROR(VLOOKUP(A2:A; {IMPORTRANGE(Y1; "Sheet1!A4:A")\
                                         IMPORTRANGE(Y1; "Sheet1!FD4:FD")}; 2; 0); ))

  • error analyzing the formula. I have created two dummy sheets to test it on. #1 link and #2 link – Marek Marhoul Apr 3 at 5:27
  • @MarekMarhoul fixed. answer updated. check your sheets – user0 Apr 3 at 11:22
  • It is working perfectly, thank you! – Marek Marhoul Apr 3 at 13:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.