Google表格-查询中的导入范围 [英] Google Sheets - Import Range within a Query

问题描述

试图运行带有内置导入范围功能的查询，但是我一直收到错误消息.这是我要使用的公式:= 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表格-查询中的导入范围的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！