Formula Optimization

2

Could you help me find a way to optimize the formula below? The spreadsheet has more than 125,000 lines with this formula in some 4 columns and is generating a lot of slowness to process the information and even to open it.

=SE(
    $D125883="Receita";
    SEERRO(
        SEERRO(
            PROCV(
                $C125883;
                'X:\(Caminho Arquivo)\[Ago.15 a Jan.18.xlsx]%Venc'!$B$5:$AK$1048576;CB$1;FALSO
            )*$R125883;
                SE(
                    PROCV(
                        $J125883;
                        'X:\(Caminho Arquivo)\[Ago.15 a Jan.18.xlsx]%Venc_Cliente'!$H$4:$J$1048576;3;FALSO
                    )=CB$2;$R125883;0
                )
        );
        'X:\(Caminho Arquivo)\[Ago.15 a Jan.18.xlsx]%Venc'!AF$9454*$R125883
    );
    SE(
        SEERRO(
            PROCV(
                $J125883;
                'X:\(Caminho Arquivo)\[Ago.15 a Jan.18.xlsx]%Venc_Cliente'!$H$4:$J$1048576;3;FALSO
            );
            'X:\(Caminho Arquivo)\[Ago.15 a Jan.18.xlsx]%Venc_Cliente'!$F$2
        )=CB$2;$R125883;0
    )
)

Thanks for the help right away.

    
asked by anonymous 09.03.2018 / 15:22

0 answers