Vlookup Importrange数组公式不起作用

Question

我一直在使用这个公式，但自从我更改了列引用后，它就不起作用了。之前它工作得很好。

我不知道自己犯了什么错误。我们将感谢您的帮助。

配方表

数据表

=ArrayFormula(IF(A3:A501="",,iferror(vlookup(B3:B501&" "&C3:C501&" "&F3:F501&" "&G3:G501,query(TRANSPOSE(TRIM(QUERY(TRANSPOSE(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1xUIHA6UIqS7II8mZttQSifcvMJy-l6tDiZmwv7fw5ls/edit#gid=462447817","Sheet1!A3:W500")),,22))),"select Col1,Col2 where Col1<>'' ",1),2,0),"NF")))

Answer 1

在H3中尝试

=ArrayFormula(IF(B3:B501="",,vlookup(trim(B3:B501&" "&C3:C501&" "&text(F3:F501, "mm/dd/yyyy")&" "&G3:G501), {transpose(QUERY(TRANSPOSE(query(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1xUIHA6UIqS7II8mZttQSifcvMJy-l6tDiZmwv7fw5ls/edit#gid=462447817","Sheet1!A3:W500"), "Select Col2, Col3, Col6, Col7")),,9^9)), IMPORTRANGE("https://docs.google.com/spreadsheets/d/1xUIHA6UIqS7II8mZttQSifcvMJy-l6tDiZmwv7fw5ls/edit#gid=462447817","Sheet1!W3:W500")} ,2,0)))

看看这是否有效？