VLookups and processing speed
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.....
|