Your *range* is probably the main reason you're searching for a faster
lookup procedure.
Do you *really* need 65,536 rows in your list?
That's what your formula is looking through with your range specifications
of $A:$D, whether or not you use a name or just the address itself.
If your list is *really* that large, you could perhaps try changing to a
different function from Vlookup, to maybe a faster Index and Match
combination.
=INDEX([your full path]$D:$D,MATCH(B1,([your full path]$A:$A,0))
If, on the other hand, your range is *not* really that large, and the only
reason you're using that large range size is because you don't want to
update the formulas as you add data, then you could try using a dynamic
range, which will automatically expand itself as you add data.
Debra Dalgleish has a web page which describes this:
http://www.contextures.com/xlNames01.html#Dynamic
Probably the fastest route that you could go is by using both a dynamic
range and the Index and Match combination.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
I have lots of links with VLOOKUP with many ranges to many
different workbooks.
Will link updating be faster if I change the range such
as =VLOOKUP(B1,'Book1.xls]Sheet1'!$A:$D,4,FALSE) to
formula with named range for example
=VLOOKUP(B1,'Book1.xls]Sheet1'!d,4,FALSE)
or it will be the same.
Thanks
