Forum Discussion

andrebrasil's avatar
andrebrasil
Copper Contributor
Sep 01, 2025

How to resolve formula discrepancy Excel/SharePoint

Good afternoon, could someone help me? The formula =IF(ISERROR(INDEX(Form1!F:F, ROW()-90)), "", IF(INDEX(Form1!F:F, ROW()-90) = "", "", INDEX(Form1!F:F, ROW()-90))) works in offline Excel, but in Sha...
excel
Excel for web
Formulas and Functions
office 365
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 03, 2025

Most probably offline Excel is not recent one (i.e. not 365 or 2021, etc). With modern Excel at row #90 we have INDEX(F:F, 0), Excel tries to return entire column F staring from the cell in row 90, we have not enough space for that, thus error.

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Sep 03, 2025

    That's a great point but I don't think it is the issue.  Only row #90 would be an issue and that would be a SPILL error, which I would think the OP would have called out specifically:

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Sep 04, 2025

      We could only make guesses, what exactly happened is not clear. Which version of "offline" Excel, is it Windows or Mac. Which locale is used locally (Portuguese is language added to Office or locale), which regional settings are used with Excel for web and SharePoint (default US or they were changed on another one). Which exactly formula is used in each case. It's given in English, Portuguese one will be

      =SE(É.ERRO(ÍNDICE(Form1!F:F; LIN()-90)); ""; SE(ÍNDICE(Form1!F:F; LIN()-90) = ""; ""; ÍNDICE(Form1!F:F; LIN()-90)))

       

Resources