我正在嘗試從存盤在 Google Sheet 中不同作業簿中的幾年資料創建一個搜索框。出于某種原因，它給出了一個#Value！錯誤，我確實遵循了正確的范圍 {} 及其相應的單元格憤怒 B3:Q，請幫助我如何解決 #Value！錯誤。
=QUERY({
IMPORTRANGE("1uNc8LNlgaw9_ru9_nfpXC7078W80gm2YQdZrtu2m21s","2004-INV-REPORT!B3:Q");
IMPORTRANGE("1_MiWf4ivI9h1sgJcCDxsZmh51AQcdlvFFRdjBRlsJHQ","2006-INV-REPORT!B3:Q")
},
"SELECT * WHERE Col2 CONTAINS '"&C2&"' or Col3 CONTAINS '"&C2&"'",0)
uj5u.com熱心網友回復：
首先，分別運行每個匯入范圍以允許訪問。然后嘗試：
=QUERY({
IMPORTRANGE("1uNc8LNlgaw9_ru9_nfpXC7078W80gm2YQdZrtu2m21s"; "2004-INV-REPORT!B3:Q");
IMPORTRANGE("1_MiWf4ivI9h1sgJcCDxsZmh51AQcdlvFFRdjBRlsJHQ"; "2006-INV-REPORT!B3:Q")};
"where Col2 contains '"&C2&"'
or Col3 contains '"&C2&"'"; 0)
假設 C2 不是數值
uj5u.com熱心網友回復：
我添加了IFERRORper IMPORTRANGE，它解決了#VALUE!錯誤。
=QUERY({
IFERROR(IMPORTRANGE("1uNc8LNlgaw9_ru9_nfpXC7078W80gm2YQdZrtu2m21s","2004-INV-REPORT!B3:Q"),{"","","","","","","","","","","","","","","",""});
IFERROR(IMPORTRANGE("1_MiWf4ivI9h1sgJcCDxsZmh51AQcdlvFFRdjBRlsJHQ","2006-INV-REPORT!B3:Q"),{"","","","","","","","","","","","","","","",""});
IFERROR(IMPORTRANGE("1qGRukbtB9m5gOoi-Ne1vR-h_F9-QiXUJZo7QLguTAIY","2007-INV-REPORT!B3:Q"),{"","","","","","","","","","","","","","","",""});
IFERROR(IMPORTRANGE("1nxMhsz_Op6nfeocOEQSbCJ9nMn6npM6JpLpCQk8zshg","2008-INV-REPORT!B3:Q"),{"","","","","","","","","","","","","","","",""});
IFERROR(IMPORTRANGE("1KFyG5A6Msl6zV0S3OVXyZQhb_D3Ui2Sx59UN54mQaiE","2009-INV-REPORT!B3:Q"),{"","","","","","","","","","","","","","","",""});
...
...
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/326444.html