Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Q: Is this vlookup statement efficient?
=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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's themost efficient way | Excel Worksheet Functions | |||
Efficient linking | Excel Discussion (Misc queries) | |||
IF and VLOOKUP - how efficient? | Excel Worksheet Functions | |||
What is more efficient | Excel Discussion (Misc queries) | |||
More efficient code | Excel Programming |