Hi Jason,

The last time I checked it was slower (but only very slightly, the overhead
of processing named ranges is not usually very high).

regards
Charles
_________________________________________
UK Cambridge XL Users Conference 29-30 Nov
http://www.exceluserconference.com/UKEUC.html

"WhytheQ" wrote in message
...
simple question:

Do Vlookup calculate quicker using named ranges?

...on a big range (e.g A1:V45000) it seems like they evaluate quicker
if a name is used in the Vlookup.
Surely this isn't true?

Any help appreciated
Jason.