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 Answer 1

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); ))

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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