Convert formula to vba

[jvoss]

Good day,
Looking to see if this can be turned into vba, revise the forumla to speed up the save & recalculation. i have wb with 21000 row spreed sheets and it is using this formula. this is slowing down to a crawl when trying to add new data or even saving.

{=IFERROR(INDEX(MASTER_LIST!$T$2:$T$10000,MATCH($C4,IF(MASTER_LIST!$M$2:$M$10000=$D4,IF(MASTER_LIST!$N$2:$N$10000=$E4,MASTER_LIST!$L$2:$L$10000)),0)),0)}

 

[ISY]

Hi

Range("A4").FormulaArray = "=IFERROR(INDEX(MASTER_LIST!$T$2:$T$10000,MATCH($C4,IF(MASTER_LIST!$M$2:$M$10000=$D4,IF(MASTER_LIST!$N$2:$N$10000=$E4,MASTER_LIST!$L$2:$L$10000)),0)),0)"

 

[jvoss]

Sorry looks like i did a bad job in explaining what is going on. the formula is in 21000 rows, not just one row. so each time i do a keystroke it recalculates and it takes over 10 min before i can do the next keystroke. even worse when i do a save, it takes over 1hour to save.

 

[jvoss]

problem resolved with removal of auto calculate..