I'm not aware of any performance degradation of VLOOKUPs between 2000 and 2003.

For tons of information about Excel performance, with special chapter for VLOOKUP, visit Charles Williams' site:

www.decisionmodels.com

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Simon" wrote in message ...
| Hi Guys,
|
| My first post on the forums. I work for a small insurance company in the UK
| using MS excel for stochastic modelling. My company has been office 2000(!)
| for a ages, and have finally taken the 'plunge' and upgraded... to office
| 2003. So far so good - I like it :).
|
| Sadly, since the upgrade, most of our models run significantly slower, as in
| they take twice/three times as long to run. We are wondering if this could be
| something to do with the implemenation of the vlookup function. The increased
| slowness seems to be proportional to the number of vlookups we have in the
| model - this is speculative, but there does look to be a pattern.
|
| Does anyone know if the implemenation has changed Excel 2000 - 2003, or if
| this could be a reason? Are there any other suggestions or has anyone come
| across this before? Parts of the models would be hard (read very hard) to
| implement without the vlookup'ing up - but it would be nice to know so we can
| avoid where possible if this is the case.
|
| Thanks,
| Simon