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