Q: Is this vlookup statement efficient?

[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?

 

[BrianB]

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
==================================