我的查询功能不断返回#Value错误，我可以找出我做错了什么
因此，我拥有此功能，
=QUERY({PAScore;DetPA;DetLabel}, "SELECT Col3 WHERE Col2 < '" & Input!P31 & "' LIMIT 1", 0)
该功能旨在返回detlabel或col3的字符串，其中detpa或col2小于输入！p31（位于帕斯科尔（Pascore））。相反，我收到一条错误消息，上面写着“无法解析函数查询参数2：no_column：col3。”
detpa和固定标签位于同一纸上，而帕斯科尔（Pascore）则在另一张纸上。固定标签包含字符串，而其他两个包含值。
我已经弄乱了几个小时，似乎无法弄清楚，所以如果有人知道什么问题，任何帮助将不胜感激！
如果需要更多信息，请告诉我！我会尽力提供它:)
按照要求，这是表格的副本。所讨论的公式是在细胞数据 b31 中。该公式的目的是做基本上的单元格上的事情，但没有格式化，并且具有更简单，更可调的公式。
所接受的答案解决了我的问题，但是对于其他任何人都有类似问题的阅读，我都必须更改范围，以使他们都有相同的row rows：D rows：D。
So I have this function
=QUERY({PAScore;DetPA;DetLabel}, "SELECT Col3 WHERE Col2 < '" & Input!P31 & "' LIMIT 1", 0)
That's meant to return a string from DetLabel or Col3 where DetPA or Col2 is less than Input!P31(which is located in PAScore). Instead, I get an error message that says "Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Col3."
DetPA and DetLabel are on the same sheet while PAScore is on a different one. DetLabel contains strings while the other two contain values.
I've been messing around with this for a couple of hours now and can't seem to figure it out, so if anyone knows what's wrong, any help would be appreciated!
If more info is needed, please let me know! I'll do my best to provide it :)
As requested, here is a copy of the sheet. The formula in question is on sheet Data in cell B31. The purpose of this formula is to do basically the same thing the cells above it do, but without the formatting and with a simpler and more adjustable formula.
https://docs.google.com/spreadsheets/d/1gKfEJzR4lvQJJUoA1tqYF4jMSgj2VApLQ-jnGgK3_CM/edit?usp=sharing
The accepted answer solved my problem, but for anyone else reading with a similar problem, I did have to change the ranges so that they all had the same amount of rows :D
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
让人认为
{pascore; detpa; Detlabel}有3列，输入！p31是数字，使用：如果
{Pascore中的每一个； detpa; Detlabel}有一列使用：asuming that each of
{PAScore; DetPA; DetLabel}has 3 columns andInput!P31is numeric, use:if each of
{PAScore; DetPA; DetLabel}has sonly one column use: