关于excel函数两个符合条件进行匹配，返回值为真/假

Question

sheet1:

sheet2:

如上两表，根据工号、姓名、日期用函数对比sheet2表中相应的值如果为0001返回sheet1表D2单位格为假，否则为真。求高手指教！

Answer 1

=if(offset(Sheet2!$B$1,match(A2&B2,Sheet2!A$2:A$100&Sheet2!B$2:B$100&"",0),match(C2,Sheet2!C$1:G$1)="0001","真","假")
数组公式，Ctrl+Shift+回车结束。向下填充。追问

有错误

追答

=if(offset(Sheet2!$B$1,match(A2&B2,Sheet2!A$2:A$100&Sheet2!B$2:B$100&"",0),match(C2,Sheet2!C$1:G$1))="0001","真","假")