我正在嘗試使用查詢運行一些嵌套的 IF 陳述句（匯入范圍到另一張表）。這樣，如果單元格 B2 是“ABC”，它將查詢 ABC 作業表并回傳該作業表上單元格的值。另外兩張紙“XYZ”和“123”也一樣，都是一個長公式。到目前為止，這是我所擁有的，任何幫助將不勝感激，謝謝！
=IF(B2 = "ABC", (query({IMPORTRANGE("[ABC URL HERE]", "This Sheet!A2:H")}, "Select Col9 where Col5 = '"&$D2&"' LIMIT 1",0,IF(B2 = "XYZ", (query({IMPORTRANGE("[XYZ URL HERE]", "That Sheet Sheet!A2:H")}, "Select Col9 where Col5 = '"&$D2&"' LIMIT 1",0,)IF(B2 = "123", (query({IMPORTRANGE("[123 URL HERE]", "Their Sheet Sheet!A2:H")}, "Select Col9 where Col5 = '"&$D2&"' LIMIT 1",0,)))))
杰羅姆
uj5u.com熱心網友回復：
嘗試：
=IF(B2 = "ABC", QUERY({IMPORTRANGE("[ABC URL HERE]", "This Sheet!A2:H")},
"select Col9 where Col5 = '"&$D2&"' limit 1", 0),
IF(B2 = "XYZ", QUERY({IMPORTRANGE("[XYZ URL HERE]", "That Sheet Sheet!A2:H")},
"select Col9 where Col5 = '"&$D2&"' limit 1", 0),
IF(B2 = "123", QUERY({IMPORTRANGE("[123 URL HERE]", "Their Sheet Sheet!A2:H")},
"select Col9 where Col5 = '"&$D2&"' limit 1", 0), )))
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/527309.html