Index and Match slowing Excel when inserting a row

[nathanmav]

Hi everyone,

I have a formula of multiple index and match in multiple worksheets my problem is when I insert a row in connected sheet it take more that a minute to insert that row.

Here is the formula:

=IFERROR(INDEX(Sheet1!$B$13:$B$1365,MATCH($G14,Sheet1!$F$13:$F$1366,0)),IFERROR(INDEX(Sheet2!$B$13:$B$945,MATCH($G14,Sheet2!$F$13:$F$945,0)),
IFERROR(INDEX(Sheet3!$B$13:$B$764,MATCH($G14,Sheet3!$F$13:$F$764,0)),
IFERROR(INDEX(Sheet4!$B$13:$B$474,MATCH($G14,Sheet4!$F$13:$F$474,0)),
IFERROR(INDEX(Sheet5!$B$13:$B$106,MATCH($G14,Sheet5!$F$13:$F$106,0)),
IFERROR(INDEX(Sheet6!$B$13:$B$35,MATCH($G14,Sheet6!$F$13:$F$35,0)),
IFERROR(INDEX(Sheet7!$B$13:$B$19,MATCH($G14,Sheet7!$F$13:$F$19,0)),"")))))))

Is there a way to make it fast or any other formula that have same result.

Thank you in advanced.

 

[alansidman]

Set the calculations in your Workbook to Manual.