I have this arrayformula where I need to match cells in a column from one worksheet to another and I used Importrange to link these two but it's giving me errors and I'm not sure what i'm missing

here is the formula

=ARRAYFORMULA(IF(ROW(A:A)=1,"Existing in Tracker Portal (Checker)",IF(ISBLANK(G:G),"",IF(ISERROR(MATCH(G:G,=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1rGfFG0jeUdcP1ynladinQalNpcuVbuz92iqF6goUqzA/edit#gid=0","Existing!A:A"),0)),"NO","YES"))))

  • 1
    Hi, welcome to WebApps. IF(ISERROR(MATCH(G:G,=IMPORTRANGE(" remove the equals (=) sign.
    – Tedinoz
    Jun 6, 2022 at 1:53
  • If "from one worksheet to another" means "from one tab to another within the same spreadsheet file", you should not be using importrange() in the first place. Use a simple range reference like Existing!A:A instead. Jun 6, 2022 at 13:05


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.