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