Slow spreadsheets getting me down - converting formula to use dynamic ranges

[kylerisi]

Hi Team,

I have a very large spreadsheet which uses lots of formula's, as a result it has slowed the performance of my sheet right down, I was told that using dynamic ranges will help me speed things up,

However I am not sure how straight forward this is.

I was hoping someone could help me convert a formula to incorporate a dynamic range - I will then use this formula as a reference to convert all my other formulas.

=ArrayFormula(iferror(INDEX('Step List'!$A:$C,MATCH(1,('Step List'!$A:$A=$A3)*('Step List'!$B:$B=H6),0),3)))

Any help to kick me off will be greatly appreciated

Kyle

 

[bhos123]

Name your ranges as explained here : https://support.microsoft.com/en-us/kb/830287

your range names are say range1 range2 range3

use specific ranges like A1:C500 rather than A:C

=ArrayFormula(iferror(INDEX('Step List'!range1,MATCH(1,('Step List'!range2=$A3)*('Step List'!range3=H6),0),3)))