Forum Discussion

scott6666667's avatar
scott6666667
Copper Contributor
Feb 19, 2025

#NAME? error continues to appear

I am constantly getting #NAME? error on files that appear to have correct formulas. This generally happens if I work on a file in the browser and then open it in excel. Example below shows an xlookup formula error. The formula is referencing a tab in the same workbook. This also happens on other formulas. Ive never seen this happen before until recently. Is there something I can do to prevent this from happening?

 

 

excel
Excel for web
Formulas and Functions

2 Replies

  • Harun24HR's avatar
    Harun24HR
    Silver Contributor
    Feb 19, 2025

    Why you are entering the formula as array formula? XLOOKUP() doesn't need to enter as array. Can you share a sample file so that we can closely look into your problem?

    • scott6666667's avatar
      scott6666667
      Copper Contributor
      Feb 19, 2025

      I dont enter it as an array. Its being changed to that after I open in excel after the browser version. Unfortunately I updated the formulas in that file so I dont have it as an example to share but here is another file with something similar. I dont include the @ in the formula but its being added when the file is downloaded or opened in excel. The formulas is fine in the browser. Sorry its not letting me upload the file.