如何在Google表格的查询中选择命名范围? [英] How to select a named range in Google Sheets' query?

问题描述

我正在尝试使用命名范围来建立查询，是否可以在查询中选择命名范围?

I'm trying to set up a query using named ranges, is it possible to select a named range within a query?

我尝试了以下操作:

=QUERY(NamedRange, "select '"&NamedRange2&"' where '"&NamedRange3&"' contains '"&B2&"' ")

我希望能够使用命名范围，而不必使用 select A where ... 或 select col1 where ... ，因为电子表格一直在运行通过修订，其中列会更改，因此我想保持查询动态，这样就不需要不断更新.

I want to be able to use named ranges instead of having to use select A where...or select col1 where... since the spreadsheet is constantly going through revisions where columns change so I want to keep the query dynamic so it doesn't constantly need updating.

推荐答案

.您可以像这样:

=QUERY({NamedRange}, "select Col1 where Col1 contains '"&B2&"'")

这篇关于如何在Google表格的查询中选择命名范围?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！