Mark Stephens

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Question on Vlookup	dharmik	Excel Worksheet Functions	4	July 22nd 05 02:12 AM
VLOOKUP Question.	StephenAccountant	Excel Discussion (Misc queries)	3	July 6th 05 10:28 PM
Vlookup question	nycguy96	Excel Discussion (Misc queries)	2	April 21st 05 04:06 PM
question about vlookup	²ÓBear	Excel Worksheet Functions	2	December 14th 04 05:09 PM
Vlookup Question	Jeff	Excel Discussion (Misc queries)	2	December 2nd 04 02:40 PM

All times are GMT +1. The time now is 02:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us