Q: Is this vlookup statement efficient?

  • Thread starter Thread starter John
  • Start date Start date
J

John

=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?
 
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
==================================
 
Back
Top