LinkBack URL
About LinkBacks
Is there a significant performance boost when I vlookup within specified range (e.g. $A$1:$A$10000) rather than the whole column (e.g. A:A)? What if I'm vlookuping this way for 2,000 values? And what about 40,000?
Is there a significant performance boost when I vlookup within specified range (e.g. $A$1:$A$10000) rather than the whole column (e.g. A:A)? What if I'm vlookuping this way for 2,000 values? And what about 40,000?
Lots of good info on efficiency here:
http://www.decisionmodels.com/
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks