I have been using this formula and it is not working since i changed the column reference. Before it was working fine.
I do not know what mistake i have did. Your help will be appreciated.
=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")))
CodePudding user response：
In H3 try
=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)))
and see if that works?