Multiple Index/Match calculates extremely slow

It is the array formulas that are slowing your worksheet down. It take about 30 seconds on my machine to recalculate as well. If you can figure out a solution without the array formulas, then you won't run to the slow calculation. If you cannot, the only solution I can think of is to change your spreadsheet to manual calculation. Then add a workbook change event to tab with the following code respectively -

Please Login or Register  to view this content.

That way the spreadsheet will only calculate one tab at a time and only when the use clicks the tab. That should cut the time down from 45 secs to about 5 secs I am guessing.

Your formulas are all referencing whole columns. Each of those is 1048576 cells. In addition the calculations that are being done take time and use resources unnecessarily.

instead of this:

MATCH(1,('Safe Locks Inventory Sheet'!$D:$D=$B$1) * ('Safe Locks Inventory Sheet'!$E:$E=E5)

consider this:

MATCH(1,('Safe Locks Inventory Sheet'!$D2:$D1000=$B$1) * ('Safe Locks Inventory Sheet'!$E2:$E1000=E5)

Just make the range references are a bit larger than the anticipated need. The largest row I see in your workbook ends at row 201.

You are very welcome. Thank you for the feedback and the rep!