View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_60_] John[_60_] is offline
external usenet poster
 
Posts: 16
Default 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?