Question re efficiency in vlookup

  • Thread starter Thread starter Mark Stephens
  • Start date Start date
M

Mark Stephens

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

more efficient way to lookup a range? 1
Slow Calculation speeds in big spreadsheet 1
Graphics cards 23
Very Slow reading excel data into an array (while opened in new xl 17
moving to C# from VC++ 6 - how does app speed compare? 4
Jet 4.0 DECIMAL type: VBA Decimal type and take up in Access 0
Question re the value of a good mother board - What do you think of AM2 1
questions about VB.NET, and uses in education 2

Back
Top