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