本文介绍了Google表格-查询中的导入范围的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
试图运行带有内置导入范围功能的查询,但是我一直收到错误消息.这是我要使用的公式:= QUERY(IMPORTRANGE("1BJ11UiLyiK3PaS2iwHEsyuMMXomdvrEkYYj_Z7bWWw4","Sheet1!A:C"),选择Col2,其中Col1 ='" A1'")
Trying to run a query with an import range function built into it, but I keep getting an ERROR message.Here is the formula I am trying to use: =QUERY(IMPORTRANGE("1BJ11UiLyiK3PaS2iwHEsyuMMXomdvrEkYYj_Z7bWWw4","Sheet1!A:C"),"Select Col2 where Col1 = '"A1"' ")
我已经在没有查询的情况下测试了导入范围公式,并且成功通过了该过程,因此,这一定与我编写查询的方式有关.
I've tested the import range formula without the query and that goes through successfully so it must be something with how I am writing the query.
推荐答案
您只需要添加&符(&).试试这个:
You just need to add ampersands (&). Try this:
=QUERY(IMPORTRANGE("1BJ11UiLyiK3PaS2iwHEsyuMMXomdvrEkYYj_Z7bWWw4","Sheet1!A:C"),"Select Col2 where Col1 = '"&A1&"' ")
干杯.
这篇关于Google表格-查询中的导入范围的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!