Forum Discussion
andrebrasil
Sep 01, 2025Copper Contributor
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...
Kidd_Ip
Sep 02, 2025MVP
How about using explicit ranges and Portuguese syntax:
=SE(ÉERRO(ÍNDICE(Form1!F1:F200; LIN()-90)); ""; SE(ÍNDICE(Form1!F1:F200; LIN()-90)=""; ""; ÍNDICE(Form1!F1:F200; LIN()-90)))