Faster Lookup Help

[Lou]

Good Day everyone, below I have a double look up in a very
large table,(26,122 cells to be exact). Needless to say
when the update process happens it takes a while, my
question is, is there a better lookup that would speed up
my update process? Ideas and suggestions would be great.

=IF(ISNA(VLOOKUP(C$1&"-"&$B2,Download2003!
$A$2:$F$5115,6,FALSE))=TRUE,0,VLOOKUP(C$1&"-
"&$B2,Download2003!$A$2:$F$5115,6,FALSE))

Thank you.
Lou

 

[Aladin Akyurek]

Try to use SETV/GETV of the morefunc.xll add-in, which you can download
from: http://longre.free.fr/english/index.html.

=IF(ISNA(SETV(VLOOKUP(C$1&"-"&$B2,Download2003!$A$2:$F$5115,6,0))),0,GETV())

 

[Charles Williams]

Hi Lou,

there are some suggestions on how to speedup lookups at

http://www.DecisionModels.com/optspeede.htm


Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm