Hi,
I am using a vlookup formula on 65k cells, looking in an array of 15k fields. The programme hangs for more than 30 minutes before I kill it.
I have increased the memory and disabled Java as per recommendations to increase performance.
What’s going on? Is there a known bug? 65k cells is not a lot.
Thanks for help.
Chris
Sort the lookup-Array on the first Column, and change the last argument in the LOOKUP-formulas from 0 to 1
( because binary search versus slow linear search )
Additional: if your use many Vlookups which are equal except the third Argument, replace many Formulas by one (Matrix)-formula like =VLOOKUP( krit ; searcharray; {2.3.4.5....}; 1 )
Karolus