I'm currently using the following function to import data from one spreadsheet to another based on a value in Column K of the source spreadsheet:
=QUERY(
IMPORTRANGE("URL","Sheet Name!A2:P1000"),
"SELECT Col1,Col2,Col3,Col6,Col7,Col8,Col9,Col10,Col11,Col12,Col13,Col14,Col15
WHERE Col11 CONTAINS 'West'",
1
)
Notice I am not importing Columns 4 & 5 (D & E) because in my destination spreadsheet, those two columns are already populated and I don't want those columns to be overwritten.
However, the formula is returning:
#REF Error: Array result was not expanded because it would overwrite data in D2.
Is it possible to edit the formula so that it skips Columns 4 and 5 when it's pasting the data into the destination spreadsheet?