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

Improve this question

1 Answer 1

Reset to default
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); ))

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

Your Answer

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

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