Using Excel 2003 on XP.

I have over 55,000 rows of data on a spreadsheet and am trying to perform a VLOOKUP durng the running of a macro. I know this is a pretty big ask so I have broken the spreadsheet down so there are only around 2,000 entries per spreadsheet prior to running the macro.

I close all other applications before running my macro but it still crashes Excel when it gets to the VLOOKUP. Apart from reducing each spreadsheet to ridiculously small numbers, is there anything else I can do to allow the VLOOKUP to occur without crashing Excel?

The VLOOKUP section of code is:
Please Login or Register  to view this content.
The lookup table consists of 3,011 rows (I can't reduce this any further). Could this be a hardware issue? Using Celeron 2.80 GHz, 1GB RAM. If so, there's no way my company will approve a hardware upgrade.

Any suggestions greatly appreciated.