Question re efficiency in vlookup
 

Does anyone know if there is a (significant) price to pay in terms of speed
or memory usage if when using a vlookup you select the whole sheet as the
array (=VLOOKUP(MAX(A:A),1:65536,2))
instead of a defined array (such as A1: G500). It is one more chore to have
to define the target array and I am just wondering if it is worth it?

ANy feedback much appreciated.

Kind regards, Mark

I don't think so, Mark. I always use named ranges and often use one that
refers to the whole columns.
*******************
~Anne Troy

www.OfficeArticles.com


"Mark Stephens" wrote in message
...
Does anyone know if there is a (significant) price to pay in terms of
speed
or memory usage if when using a vlookup you select the whole sheet as the
array (=VLOOKUP(MAX(A:A),1:65536,2))
instead of a defined array (such as A1: G500). It is one more chore to
have
to define the target array and I am just wondering if it is worth it?

ANy feedback much appreciated.

Kind regards, Mark