Forum Discussion
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...
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:
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)))