Thread
:
Q: Is this vlookup statement efficient?
View Single Post
#
2
Posted to microsoft.public.excel.programming
BrianB
external usenet poster
Posts: 109
Q: Is this vlookup statement efficient?
You could, of course, do your own experiment.
Putting the explicit range will calculate faster because Excel does
not need to do the extra work of referring to the name to get the
range. Whether the overall time difference is material will depend on
the size of your workbook.
You can still name the range for use elsewhere.
Regards
BrianB
==================================
(John) wrote in message . com...
=VLOOKUP($N17&" Total",DVD_Catalog,4,FALSE)
Is this function's range argument, "DVD_Catalog", too non-specific?
I.e, would assigning a range (DVD_Catalog!a1:z1) be faster...or does
Excel default to looking up values in the first column only when there
is no range given, in which case there would not be any signficant
performance improvement?
Reply With Quote
BrianB
View Public Profile
Find all posts by BrianB