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" <mark@expatgold.com> wrote in message
news:dcmlua$i0e$1@mawar.singnet.com.sg...
> 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
>
>