Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Slow Computer
Hello,
I have a spreadsheet that has about 1000 lookup formulas. It is a little slow on the office PC. Maybe I can inprove it a bit. Which would be faster: =IF($B15="","",IF(VLOOKUP($B15,DayData,F$65,FALSE) ="","",VLOOKUP($B15,DayData,F$65,FALSE))) or this: =IF($B15="","",IF(OFFSET('Raw Data'!B9,MATCH(B15,'Raw Data'!B11:B378,0),MATCH(F9,'Raw Data'!C9:AQ9,0))="","",OFFSET('Raw Data'!B9,MATCH(B15,'Raw Data'!B11:B378,0),MATCH(F9,'Raw Data'!C9:AQ9,0)))) Thanks, Ernst. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
slow navigation | Excel Discussion (Misc queries) | |||
Excel Files Open Slow | New Users to Excel | |||
Autocomplete works with my home computer but not the office computer | Excel Discussion (Misc queries) | |||
Slow opening files - possible cause and solutoin | Excel Discussion (Misc queries) | |||
Copy macros to new computer | Excel Worksheet Functions |