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.