Offset vs vlookup functions

D

Darby

I have a 20mb file that is using a whole series of vlookup functions. It is
quite slow in calculating. Does anyone know whether the calculation would be
quicker or slower if I switched them to an offset function?

Thanks
 
J

Jim Thomlinson

Offset is a volatile function. That means that it must calculate every time a
calculation runs. This is simlar to the now or rand function. So generally
speaking you want to avoid having too many volatile functions. One thing you
could consider is swapping out yoru vlookup functions for index/match
functions which in some circumstances are faster... Check out this link

http://www.decisionmodels.com/optspeede.htm
 
Top