Hi
I wonder if someone out there might be able to help me regards to vlookup performance with different versions of Excel.
I've been told that later versions of Excel are more CPU intensive, but all I can see is that all versions of Excel can be CPU intensive when calculating - I see CPU time reduce with later versions.
We have a spreadsheet with approximately 800,000 vlookups to another sheet in the same spreadsheet. The complaint is that Excel or the configuration of Excel is not performing as they believe it should, I'm just not so sure. Should excel be able to handle this volume of lookups in an acceptable time, naturally the more CPUs the quicker the calculation
Below is an example of the lookup we are using "=VLOOKUP(B2,'VS billed'!C:G,5,TRUE)".
Any input would be greatly received
thanks in advance
I wonder if someone out there might be able to help me regards to vlookup performance with different versions of Excel.
I've been told that later versions of Excel are more CPU intensive, but all I can see is that all versions of Excel can be CPU intensive when calculating - I see CPU time reduce with later versions.
We have a spreadsheet with approximately 800,000 vlookups to another sheet in the same spreadsheet. The complaint is that Excel or the configuration of Excel is not performing as they believe it should, I'm just not so sure. Should excel be able to handle this volume of lookups in an acceptable time, naturally the more CPUs the quicker the calculation
Below is an example of the lookup we are using "=VLOOKUP(B2,'VS billed'!C:G,5,TRUE)".
Any input would be greatly received
thanks in advance