D
dee
Hi there,
Can anyone explain why using vlookup would seem to be so resource heavy?
Can anyone explain why using vlookup would seem to be so resource heavy?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Toppers
Take a look here and see if there is anything you can apply to your
situation. The performance is dependent on the number and type of VLOOKUP e.g
exact matches take longer than approximate matches..
http://www.decisionmodels.com/optspeede.htm
situation. The performance is dependent on the number and type of VLOOKUP e.g
exact matches take longer than approximate matches..
http://www.decisionmodels.com/optspeede.htm
D
dee
Thanks for your answer. It makes sense if Excel has to perform more complex
evaluations, such as exact match, that it would slow the system down.
I tried clicking on the link you suggested, but the page couldn't be
displayed. I'll try again in a bit.
evaluations, such as exact match, that it would slow the system down.
I tried clicking on the link you suggested, but the page couldn't be
displayed. I'll try again in a bit.
D
dee
Thanks so much. What a great Web site! I will be studying the content of
the page you sent me.
Thanks again!
the page you sent me.
Thanks again!