View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] fred.sheriff@gmail.com is offline
external usenet poster
 
Posts: 5
Default 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.....