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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top