View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JavyD
 
Posts: n/a
Default 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))