Formula slowing down spreadsheet calculation time

[Vegas01]

Afternoon everyone

I have the formula below and seems to be taking a real long time to calculate and slowing work time.

=IF(F8=6295,INDEX('Pricelist (6 Account) disc'!$D:$D,MATCH(1,('Pricelist (6 Account) disc'!$B:$B=$B8)*('Pricelist (6 Account) disc'!$E:$E=MAX(IF(('Pricelist (6 Account) disc'!$B:$B=$B8)*('Pricelist (6 Account) disc'!$E:$E<=ABS($D8)),'Pricelist (6 Account) disc'!$E:$E,0))),0)),INDEX('Pricelist (5 accounts)'!$G:$G,MATCH(1,('Pricelist (5 accounts)'!A:A=$B8)*('Pricelist (5 accounts)'!$D:$D=MAX(IF(('Pricelist (5 accounts)'!$A:$A=$B8)*('Pricelist (5 accounts)'!$D:$D<=ABS($D8)),'Pricelist (5 accounts)'!$D:$D,0))),0)))

Page "Pricelist (5 accounts)" has 15,000 lines
Page "Pricelist (6 Account) disc" has 19,000 line
Page doing the formula on has 1,600 lines

Added another 1,600 lines and took 2 minutes to calculate, I that does not seem long but it is annoying, I know it is this formulas as I have done test with the workbook with the formula in and out.

Any reason why it taking so long to calculate.

Thanks in advance

 

[Anonymous1378]

Have you tried not using full column references like 'Pricelist (6 Account) disc'!$B:$B and instead using 'Pricelist (6 Account) disc'!$B1:$B20000?
Or use an excel table so that you can use structured references instead?

 

[Vegas01]

Anonymous 1378 thanks for that I will look into it.