Thread: Slow Computer
View Single Post
  #1   Report Post  
 
Posts: n/a
Default 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.