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...
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.
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: