基于与其他工作表匹配的列的Google工作表查询 [英] Google Sheet Query Based on Matching Columns to Other Sheet

问题描述

提供此Google表格:

我有以下标签:

Leads To Date
All Enrolled To Date
Leads Never Enrolled

我需要最后一个选项卡Leads Never Enrolled，以使First Name和Last Name列中的Leads To Date中的所有记录都不在All Enrolled To Date中.

I need the last tab Leads Never Enrolled to have every record from Leads To Date that is not in All Enrolled To Date, per the columns First Name and Last Name.

我已经尝试使用QUERY函数，但是我不确定如何在搜索参数中集成对名字和姓氏的匹配.

I have tried using the QUERY function, but I'm not sure how to integrate matching on first and last names within the search argument.

提前谢谢！

推荐答案

您可以使用FILTER:

=FILTER('Leads To Date'!A:C,COUNTIF('All Enrolled To Date'!A:A&'All Enrolled To Date'!B:B,'Leads To Date'!A:A&'Leads To Date'!B:B)=0)

这篇关于基于与其他工作表匹配的列的Google工作表查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！