replace this reference worksheet function with some vba code that will loop through a specified range and do the same as a vlookup without the "live" calculation of your spreadsheet... then no need of a new computer, I'm doing all I want using vba for Excel, Access, Outlook, Word, PowerPivot... with my single core laptop

Choosing a computer may be more related to your application needs e.g video/audio, office application, gaming