Slow Calculation
hello Everyone,
This small formula over 300 rows and 16 columns takes about 20 mins, can I
minimize that?
=IF(ISERROR(VLOOKUP($A7,'CHE all sku'!$A:$Z,'MTL
aux'!B7,FALSE)),0,VLOOKUP($A7,'CHE all sku'!$A:$Z,'MTL
aux'!B7,FALSE))-IF(ISERROR(VLOOKUP($A7,'CHE MBE sku'!$A:$Z,'MTL
aux'!B7,FALSE)),0,VLOOKUP($A7,'CHE MBE sku'!$A:$Z,'MTL
aux'!B7,FALSE))-IF(ISERROR(VLOOKUP($A7,'CHE MEX sku'!$A:$Z,'MTL
aux'!B7,FALSE)),0,VLOOKUP($A7,'CHE MEX sku'!$A:$Z,'MTL aux'!B7,FALSE))
|