| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup slows system
Hi there,
Can anyone explain why using vlookup would seem to be so resource heavy? -- Thanks! Dee |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup slows system
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 "dee" wrote: Hi there, Can anyone explain why using vlookup would seem to be so resource heavy? -- Thanks! Dee |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup slows system
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. -- Thanks! Dee "Toppers" wrote: 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 "dee" wrote: Hi there, Can anyone explain why using vlookup would seem to be so resource heavy? -- Thanks! Dee |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup slows system
Thanks so much. What a great Web site! I will be studying the content of
the page you sent me. Thanks again! -- Thanks! Dee "Toppers" wrote: 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 "dee" wrote: Hi there, Can anyone explain why using vlookup would seem to be so resource heavy? -- Thanks! Dee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering slows down a macro | Excel Worksheet Functions | |||
| Excel worksheet slows computer | Excel Worksheet Functions | |||
| Excel slows down for no(?) reason... | Excel Discussion (Misc queries) | |||
| ifsum slows down calculations | Excel Worksheet Functions | |||
| excel causing system to be in low system resource | Excel Discussion (Misc queries) | |||
Linear Mode
