因此，此公式將 3QUERY()包裝為 1，以便垂直設定結果。問題是，當其中一個查詢沒有找到任何值時，它會回傳一個#VALUE說法：In ARRAY_LITERAL, an Array Literal was missing values for one or more rows.
我已經嘗試過IFERROR()，將其全部包裝在另一個 rQUERY()中，但它不起作用。
=QUERY({
query({Sheet1!A:FR},"Select Col142,Col11,Col12,Col74 where Col7 = '"&P4&"' and not Col142 contains '#N/A' and not Col142 matches '-' and Col142 is not null",0);
query({Sheet1!A:FR},"Select Col150,Col11,Col12,Col78 where Col7 = '"&P4&"' and not Col150 contains '#N/A' and not Col150 matches '-' and Col150 is not null",0);
query({Sheet1!A:FR},"Select Col152,Col11,Col12,Col82 where Col7 = '"&P4&"' and not Col152 contains '#N/A' and not Col152 matches '-' and Col152 is not null",0)
},"select * where Col1 <> '#N/A' and Col1 is not ''")
感謝你的幫助！
謝謝！
uj5u.com熱心網友回復：
您必須對每個單獨的查詢應用 iferror 并給出一整行空白，即
iferror(query(_____________),{"","","",""})
如果查詢應該每行獲取 4 個結果
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/496025.html
上一篇：谷歌表格，如果沒有，宣告無效