Fred
Why don't you post a little more detail about what is going on in your spreadsheet. My laptop without a whole lot of memory will process 1 million vlookups in a second or so. Maybe there is some inefficiency built in that could be rectified making your current computer more adequate.
Ken


On Saturday, November 17, 2012 7:17:20 PM UTC-5, 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....