Slow Computer

I

info

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.
 
Top