當我使用IF它時，它完美無缺。
=IF(H6="Vaga", QUERY(A2:D60, "SELECT * WHERE A "&H3&"
"&H9&"'"),QUERY(A2:D60, "SELECT * WHERE C "&H3&" '"&H9&"'"))
但是當我嘗試時IFS，它說行數和列數有錯誤
=IFS(H6="Vaga", QUERY(A2:D60, "SELECT * WHERE A "&H3&" '"&H9&"'"),
H6="Empresa", QUERY(A2:D60, "SELECT * WHERE C "&H3&" '"&H9&"'"),
H6="Postada", QUERY(A2:D60, "SELECT * WHERE E "&H3&" '"&H9&"'"))
uj5u.com熱心網友回復：
我不知道為什么它不起作用，但是IFS對陣列有一些限制，并且可能對query. 然而，您的公式的一個簡單解決方案似乎只是推斷出多個 if 陳述句：
=IF(H6="Vaga", QUERY(A2:D60, "SELECT * WHERE A "&H3&" '"&H9&"'"),
if(H6="Empresa", QUERY(A2:D60, "SELECT * WHERE C "&H3&" '"&H9&"'"),
If(H6="Postada", QUERY(A2:D60, "SELECT * WHERE E "&H3&" '"&H9&"'"),"nothing")))
uj5u.com熱心網友回復：
嘗試：
=QUERY(A2:D60, "where "&
CHOOSE(MATCH(H6, {"Vaga","Empresa","Postada"}, ), "A","C","E")&H3&" '"&H9&"'")
見：https : //webapps.stackexchange.com/a/124685/186471
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/365202.html