| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLookups and processing speed
Hi fred.
there is no need to buy any new computer just use index and match formula to pull the data as it run much faster then Vlookup. Regards Prince On Sunday, November 18, 2012 5:47:20 AM UTC+5:30, wrote: I am going to buy a new computer. Much of what i currently have to wait for is for a vlookup to complete in Microsoft excel. Some lookups...when I am pulling from two tables of several hundred thousand rows....can take hours to complete. Do I need to get a computer with 3+ GHZ of processing power as the primary way to improve how long I have to wait for these lookups in excel.....or is more ram or something else needed? ? Thx for any suggestions.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I improve processing speed of macro | Excel Programming | |||
| Can I improve processing speed of macro | Excel Programming | |||
| Why does adding columns slow down processing speed? | Excel Programming | |||
| speed of processing | Excel Programming | |||
| Free Tool (Add-in) To Speed Up Your Data Processing | Excel Worksheet Functions | |||
Threaded Mode
