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)}
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)}