# Index and Match slowing Excel when inserting a row

#### nathanmav

##### Board Regular
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.

Last edited:

### Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

#### alansidman

##### Well-known Member
Set the calculations in your Workbook to Manual.

Replies
4
Views
213
Replies
3
Views
92
Replies
5
Views
83
Replies
3
Views
58
Replies
2
Views
97

1,109,426
Messages
5,528,690
Members
409,830
Latest member
KT50

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
• VBA vlookup multiple results
Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
• Extract values for earliest/latest times
I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...