Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need mor Speed!!!!
Can anybody tell me if this will give more speed to mi file :
I have this formula in 3 columns for 12 months & for 85 rows down & in 4 worksheet in the same file, this makes aprox 12 K cells that have the formula, but it is loading the actual by month, example, I have Jan Actual & rest of the Year 0.00, Right now I have this: =IF(ISERROR(VLOOKUP(" "&$B6,Xsears2,2,FALSE)), ,VLOOKUP(" "&$B6,Xsears2,2,FALSE)) This just goes & graves the units sold in a table "xsears2 for a part number in B6 and returns a 0.00 if nothing is found. Right now it takes a wile to calculate & I was wondering if this could make it faster =IF(G4=" ",0,(IF(ISERROR(VLOOKUP(" "&$B5,Xsears2,2,FALSE)), ,VLOOKUP(" "&$B5,Xsears2,2,FALSE)))) If I input actual into G4 this will activate the formula, if no actual it will just return 0.00, Please can someone help me, I really dont want to change the formulas in all of my worksheets |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|